Please notice, that Employee ID’S are not unique values. Unique value are Event ID column only. Most of employees are assigned to more than one event and I need count them with 4 or more events.
EDIT: It’s because you have the > = 4 = in your measure. Therefore PBI will check wehter 4 is equal to the value returned by the countrows. If you want to rename the measure correctly, use: ≥ (see attached file as well. this should work.
When I change it to >= 4, I still get the values. Are you sure you created the relationship between dimension and fact table correctly?
Based on your printscreen of your measure, I assume you replicated my model. I didn’t use an underscore _ in my dimension tables. Since you replicate the model, make sure you replicate it in the exact same way.
I would love to help, but for that I need more context and explanation.
What do you exactly mean by ‘creating measures without creating extra tables’ of course you can, just add new measure ? This should be possible with direct query if I am correct.
And how do you concluded it didn’t spot all the employers ? Please provide more context / data that support this conclusion, that would improve my ability to assist further.
Hope I don’t sound harsh, just want to help and therefore need to understand the problem first
And I will look futher into it
