Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Issue on Exclude members based on selected filters.
Sample Data:
Table Name:Sample
ID | Colour |
1 | RED |
2 | RED |
3 | WHITE |
4 | BLACK |
5 | |
6 | WHITE |
7 | |
8 | BLACK |
9 | BLUE |
10 | RED |
Impotance:
if user selects any colour that member count should be exclude.
for example if i selected Colour(red) then my member count should be 7 (10-3)
I used logic here:
Step 1: i created below table
Table name:New
Colour1 |
RED |
WHITE |
BLUE |
BLACK |
Step 2:I created below mesure
member var sel=selectedvalue('New'[Colour1])
return
if(sel=selectedvalue(Sample[Colour]),0,1)
This measure working fine where we see the visualization in table format. But i need to get member counts in visualization.
I need to get below output
FIlter Selection:
Colour |
Red |
White |
Blue |
Black |
Total Count:
10
If you user select Colour(Red), my total count should be 7 in visualization.
Note:
Selected slicer count should be excluded from my total count.
Thanks,
Sai kiran.
Solved! Go to Solution.
this will work (unless nothing is selected)
Total Count = calculate(COUNTROWS('Sample'),all('Sample'))- COUNTROWS('Sample')
or simpler
Total Count = COUNTROWS(all('Sample'))- COUNTROWS('Sample')
this will work (unless nothing is selected)
Total Count = calculate(COUNTROWS('Sample'),all('Sample'))- COUNTROWS('Sample')
or simpler
Total Count = COUNTROWS(all('Sample'))- COUNTROWS('Sample')
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.