filtering within measure column

[refint650]

Hello 

How to write filter expression in measure column , below condition doesnt seem to work unless i use visual filter.

CALCULATE ( DISTINCTCOUNT( ID ), Filter( ID <> "" && Name  = "" ) )  or should i calculate table since filter whole table data.

KP.

[v-henryk-mstf · Accepted solution]

Hi @refint650 ,

You need to use the correct filter criteria. Reference is as follows:

M = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    FILTER ( ALL ( 'Table' ), 'Table'[ID] <> BLANK () && 'Table'[Name] = BLANK () )
)

If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[refint650]

@ashish

not exactly 

distinctcount(ID),  where name <> "" and Flag ="" .

[Ashish_Mathur]

My suggested measure should work.  Share the link from where i can download your PBI file.  Show the incorrect answer and also let me know the exact result that you are expecting.

[Ashish_Mathur]

Hi,

Does this work?

=CALCULATE(DISTINCTCOUNTNONBLANK(Data[ID]),Data[Name]=BLANK())

Hope this helps.