Forum Discussion
Show Distinct Count on a card based on multiple selections
I have to create a report where we have to show which flags are linked to which accounts. I have a slicer with the 12 flags (1-12) and it filters down to the main table showing account info. It conta...
Hi Anonymous ,
So basically you want filter the table according to selected flags and distinct count the bill to account? But what's the relationship between the flags and the table you shown above? Do you have flag column in the table above?
Best Regards,
Jay
Yes that is correct
I have a flag measure on the visual with the account information. I set it to "shows items when the value is _1_ "
the measure:
Invoices with all selected flags =
Var FLAGTYPECT = DISTINCTCOUNT('TABLE'[FLAG])
Var FLAGTYPEROWS = COUNTROWS(ALLSELECTED('TABLE'[FLAG]))
Var Result = IF(FLAGTYPECT = FLAGTYPEROWS, 1, 0)
RETURN
Result