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 measu...
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

v-cherch-msft's avatar
v-cherch-msft
Microsoft 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