Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Countx measure visual lags

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!
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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