Forum Discussion
Exclude members based on selected filters.
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.
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')
1 Reply
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')