Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Li1i6n
Frequent Visitor

Wish KPI of unique number of client_ID/city/product from 2 tables

I have 2 tables from Snowflake

table_A with inc_ID, cl_ID, city, product plus 10 other columns
table_B with inc_ID, cl_ID, city, product plus 25 other columns
Wish KPI of unique number of client_ID/city/product from 2 tables
my dax: INC_cl = DISTINCTCOUNT(TABLE_A[cl_ID]) + DISTINCTCOUNT(TABLE_B[cl_ID])
expecting: number of unique cl_ID of table A en B together
result: some numbers are double

which dax do I have to use?

2 REPLIES 2
Li1i6n
Frequent Visitor

Thanks amitchandak, I was thinking too to do that...
Table_A is ending and will not filled anymore (it has data of period Jan 2022 till Jun 2022), Table_B is the follow-up of Table_A with more colums (it has data from period Jul 2022). That's why I hoped to solve it with DAX in stead of create a new combination table.
Do you have suggestions with this added information?

amitchandak
Super User
Super User

@Li1i6n , I think you should create some common tables and analyze measures with those

 

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors