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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=SUMX(FILTER(SUMMARIZE(Table2,Table2[Category],"counts",COUNTA (Table2[Category])),[COUNTS]>1).[COUNTS])