Distinct Count of Two Columns plus not Blank using DAX

[Anonymous]

Hello Everyone,

I need urget help with Distinct count based on two column and also ignoring blank in the data with DAX in power BI

So i need column E and Column F distinct count and ignoring blank. So currently there is 37 data total and after distinct count of two column and ignoring blanck there the total count should be 31.

I have uploaded excel file with dummy data at below link.

https://drive.google.com/open?id=109V7P00IfkABYcCS6DslzK0eY58EPzVF

Urgent help would be highly appreciated. 

Thanks

[AlB · Accepted solution]

Hi @Anonymous

A simple way would be to create a calculated column in your table concatenating Col E and Col F like this:

Table1[Column G] = Table1[Column E] & Table1[Column F]

and then place 'Column G' in a Card visual, select to show the distinctcount on the fields pane and use a filter to get rid of the blanks.

Otherwise you can create a measure like this and place it in a Card visual:

Measure=CALCULATE(DISTINCTCOUNT(Table1[Column G]),
                                Table1[Column G] <> BLANK()
                 )