Countx measure visual lags

[Anonymous]

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:

Count_Neg_EBITDA_TTM =

COUNTX (

FILTER ( ALLSELECTED ( Actuals[Location] ), [EBITDA_TTM] < 0 ),

[EBITDA_TTM]

)

Could anyone point me in the right direction to improve this from a performance standpoint? Any help would be greatly appreciated!

[v-cherch-msft · Accepted 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