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.
Urgent help would be highly appreciated.
Go to Solution.
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
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!