Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago
Solved

Incorrect Total showing

why would the total still count everything?   measure = CALCULATE(COUNTROWS(Table2), FILTER(Table2, COUNTROWS(Table2) > 1) )   how does one adjust the grand total to reflect the correct amount? ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi vanessafvg,

     

    Based on my test, the formula below should work in your scenario. :smileyhappy:

    Measure 2 =
SUMX (
    SUMMARIZE ( Table2, Table2[Category], "counts", COUNTA ( Table2[Category] ) ),
    IF ( [counts] > 1, [counts] )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi vanessafvg,

 

Based on my test, the formula below should work in your scenario. :smileyhappy:

Measure 2 =
SUMX (
    SUMMARIZE ( Table2, Table2[Category], "counts", COUNTA ( Table2[Category] ) ),
    IF ( [counts] > 1, [counts] )
)

 

Regards