Help needed urgently with 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

You could create a new calculated column concatenating Col E and Col F:

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

and then place the following measure in a Card visual:

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