Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I am creating a financial dashboard that shows summarized results based on a transaction level data table. I have several measures to calculate these summarized results. For example, I have measures to calculate the trailing 12 months revenue and EBITDA. I have added a measure to calculate the count of location codes that have a negative trailing 12 month EBITDA. My calculation works, however, from a performance standpoint, it makes my visuals quite slow when I change the region or date slicer. Here is the measure I am currently using that is so slow:
Solved! Go to Solution.
Hi @Anonymous
Please try below measure.
Count_Neg_EBITDA_TTM = IF ( [EBITDA_TTM] < 0, COUNTX ( ALLSELECTED ( Actuals[Location] ), [EBITDA_TTM] ) )
Or
Count_Neg_EBITDA_TTM = COUNTROWS ( FILTER ( ALLSELECTED ( Actuals[Location] ), [EBITDA_TTM] < 0 ) )
Regards
Hi @Anonymous
Please try below measure.
Count_Neg_EBITDA_TTM = IF ( [EBITDA_TTM] < 0, COUNTX ( ALLSELECTED ( Actuals[Location] ), [EBITDA_TTM] ) )
Or
Count_Neg_EBITDA_TTM = COUNTROWS ( FILTER ( ALLSELECTED ( Actuals[Location] ), [EBITDA_TTM] < 0 ) )
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |