Forum Discussion

Regular Visitor

6 years ago

powerbi

I have net net revenue ,net engagement margin ,client name ,em%(em/nr) by each fiscal year.I need to calculate client count for 80% of em?

Community Support

6 years ago

Please try like this:

Measure = COUNTROWS(FILTER('Table',[em%]>=0.8))

Measure = COUNTROWS(FILTER(ALLEXCEPT('Table','Table'[fiscal year]),[em%]>=0.8))

If they don't work, please share some sample data and expected output. We will understand clearly.