Count number of entities filtered by a measure

[Anonymous]

Hi everyone,

I need some help for a little measure.

I want to calculate the number of ill entities.

An entity is ill if it got a value > 0 during 3 months in a row.

I did a measure that determines if an entity is sick, but I don't succeed in determining the global number, or the number according to some parameters (like sexe, age...).

I tried to do it by filtering my fact table with my measure but I think I didn't make it well because that didn't work (That's why I'm there :))

Thank you in advance,

(By the way, don't hesitate to correct my english errors, I'm doing my best but I'm pretty sure that's burning english eyes 😕 )

[Nathaniel_C]

@Anonymous ,

It would be helpful to supply us with your pbix, or at the very least some dummied up tables from Excel showing us what you have and also what you want the result to be. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Nathaniel

[Anonymous]

Ok, I explain :

This is an exemple of my fact table.

I already did a measure that say me if a Client is ill.

He's ill if he have a sickness rate >= 20% 3 months in a row.

Now, I want a measure that give me the number of clients ill by group, but I don't succeed in doing that measure.

Thanks,