cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vector01 Frequent Visitor
Frequent Visitor

Help needed urgently with DAX

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Help needed urgently with DAX

Hi @vector01

 

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()
)

 

View solution in original post

1 REPLY 1
Super User III
Super User III

Re: Help needed urgently with DAX

Hi @vector01

 

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()
)

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors