Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hi, I'd like to write a measure to calculate total distinct items from 1 column that not found in another column. 2 columns are from different tables.
I was able to do this my adding a calculated helper column, but just wondering if there is any way to do it without adding an extra column.
Column A from table 1
Column B from table 2
I want to count distinct items from Column A not found in Column B.
There are 5 items in Column A not found in Column B:
And there are 3 distinct counts: CC DD and EE, so the measure should return 3.
Go to Solution.
@yuanye0710 , except can help
In A not in B
a new table = except(distinct(TableA[COlumn]), distinct(TableB[COlumn]) )
a new table = Countrows(except(distinct(TableA[COlumn]), distinct(TableB[COlumn]) ) )
View solution in original post
Thanks a lot! it's working for me!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.