Forum Discussion
How to count selected items in slicer?
I created a slicer with two items (Supplier 1 and Supplier 2), I was trying to count the selected items from this slicer, but what I found is that the count result would be the same when I selected b...
Hi Anonymous
Would you like Page1 or Page2?
Page1
Page2
Measure 2 = IF(HASONEVALUE(Table1[name]),[Measure],SUMX(Table1,[Measure])) Measure 3 = SUMX(ALL(Table1),[Measure])
This works not only for tow items but also work for more.
Best Regards
Maggie
How to have the column "value" in Table 1? Should I sipmy add a columns and fill with "1"? If I do this, I do not see the symbol "Σ" next to value. Thank you