Hi,
I have 2 columns. ID's and Roles. Each ID is assigned with Multiple Roles. I have added Roles in Filter and Count(ID's) in KPI measure Value.
If I select 2 roles in Filter , KPI value showing summation of ID's Count. ( like Role 1 assigned to 10 ID's and Role 2 assigned to 5 ID's means , KPI will show 15 as count)
But now I have the requirement, If i select 2 Roles in Filter, KPI value has to show count of ID's who has both the roles assigned.( like Role 1 assigned to 10 ID's and Role 2 assigned to 5 ID's means , but only 4 ID's has both the Roles assigned , then KPI has to show 4 as count)
Any way to achieve this