Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @3cdoug
just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter
CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100
Hi @3cdoug
just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter
CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |