How to exclude blank and other values in the calculate measure

[saivina2920]

I have the following measure.

I just want to exclude and "Others" values in the calculate measure.

How to do this...?

below is my current measure.

var working = CALCULATE(COUNTROWS(Table1),FILTER(ALL(Table1),Table1[Dep-A]= "working"

&& Table1[Region]=sel))

I have added the below condition. but, it is not working.

var working = CALCULATE(COUNTROWS(Table1),FILTER(ALL(Table1),Table1[Dep-A]= "working"

&& NOT(Table1[Dep-A]= "Others") && (Table1[Dep-A] <> BLANK()) && Table1[Region]=sel))

How to exclude the blank and other values from the calculation filter.

below is the column value to filter.

Dep-A

Working

Not Working

Working

Not Working

Working

Working

Not Working

Working

Others

Others

[Anonymous]

@saivina2920 

Please try

Test = 

CALCULATE(
    COUNTROWS(Sheet1),
    FILTER(ALL(Sheet1[Column1]),
    Sheet1[Column1] <> ""),
    Sheet1[Column1] <> "Others")

If this helps, please mark this as a solution

BR

Dax_noob

[saivina2920]

Sorry. it's not working...showing syntax error.

[Anonymous]

Hi @saivina2920 

Could you paste your code here.

Regards

[saivina2920]

Hi @Anonymous ,

Thanks for your help,

i am trying to form donut chart using the above measure.

But, i don't want to show the "others" and blank in the donut chart.

How to remove the blank and "others" in the donut chart.

pls. find the below url for reference file.

https://1drv.ms/u/s!AiSRcgO5FUmN8XJ-eOtEUgea8stk?e=LGj1rb 

[saivina2920]

Hi @Anonymous ,

Can you pls. correct the measure which is attached my file with this..

this is very important.

[Anonymous · Accepted solution]

Hi @saivina2920 ,


Step 1: Create a new measure

M_Dept-A 2 = 

CALCULATE(
    COUNT(DummyTable[Dept-A]),
    KEEPFILTERS(
        DummyTable[Dept-A] <> "" &&
        DummyTable[Dept-A] <> "Others")
)

Step 2 : Visualize

Hope that helps

[saivina2920]

Yes. It's perfect...Thanks...