Measure count as filter to create a new measure

[Anonymous]

ID count = CALCULATE(COUNT('Reporting Absence'[Id]),FILTER('Reporting Absence',[Absence count]>=6))

I am trying to count the number of ID that have more than 6 absences. But it shows blank.

Is there anything wrong?

[V-lianl-msft]

Hi @Anonymous ,

According to the DAX formula you provided, I tested it without any problem. Can you provide the sample pbix or the formula of [Absence count]?

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

[Anonymous]

The absent count is a measure not a calculated column... I guess that's the reason why its not working?

[amitchandak]

Count More than 6 absence means you need group data at a level and then filter it. You need to use values to group data at a level.

It would be something like this

Absence count = COUNT('Reporting Absence'[Id])

ID count = CALCULATE(SUMX(values('Reporting Absence'[Id]),Absence count ),FILTER('Reporting Absence',[Absence count]>=6))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

I tried to create the absent count and ID count with measures. It still returns blank...

[V-lianl-msft]

Hi @Anonymous ,

Could you provide the sample pbix or the DAX formula of [Absence count]?(Please mask any sensitive data before uploading)

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

[amitchandak]

To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Ashish_Mathur]

Hi,

Does this work?

ID count = CALCULATE(COUNTROWS('Reporting Absence'),'Reporting Absence'[Absence count]>=6)

My assumption is that Absence count is a column in your dataset.