Exclude members based on selected filters.

[Anonymous]

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.

[lbendlin · Accepted 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')