Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Proud to be a Super User!
Solved! Go to Solution.
Hi @vanessafvg,
Based on my test, the formula below should work in your scenario.
Measure 2 = SUMX ( SUMMARIZE ( Table2, Table2[Category], "counts", COUNTA ( Table2[Category] ) ), IF ( [counts] > 1, [counts] ) )
Regards
Hi,
Try this
=SUMX(FILTER(SUMMARIZE(Table2,Table2[Category],"counts",COUNTA (Table2[Category])),[COUNTS]>1).[COUNTS])
Hi @vanessafvg,
Based on my test, the formula below should work in your scenario.
Measure 2 = SUMX ( SUMMARIZE ( Table2, Table2[Category], "counts", COUNTA ( Table2[Category] ) ), IF ( [counts] > 1, [counts] ) )
Regards
Check out this blog post by PowerPivotPro:
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |