Count within a group ?

[Anonymous]

CM	Naam
Show	Jan
No Show No Message	klaas
No Show With Message	Jan
No Show No Message	Jan
No Show No Message	Jan
No Show No Message	Klaas
No Show With Message	Jan
No Show With Message	Klaas

I would like to count the number of "No Show No Message"  but only if "Show" doesnt exist for that user (for a selected period)

So the result of my measure would be: 2

( The 2 "No Show No Message" from Klaas, Jan isnt counted because he has an "Show"

[v-xicai]

Hi @Anonymous ,

You can create measure like DAX below.

Measure1= CALCULATE(COUNT(Table1[CM]),FILTER(ALLSELECTED(Table1), Table1[Naam] =MAX(Table1[Naam])&&Table1[CM]= "No Show No Message"))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your reply.

But how do you account for the "Show" and the user(Naam) 

I any user(naam) has a "show" doesnt somewhere in the selected period the "No Show No message" should not count

[v-xicai]

Hi @Anonymous ,

I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy