Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Best approach for calculating counts

Hey All, Looking for the best/correct approach to add a calculated count column to a table. I have a clients table which is simple at first sight. Status Type Sex Count   The count colu...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Confused about what is your desired output now, for example the relationship between the main table and other table.

 

 

 

 

 

 

 

 

 

If you need to create relationship between two tables which have no foreign key, you can create intermediate table like DAX below, then create relationships between this intermediate table and other two tables.

 

intermediate table = CROSSJOIN(DISTINCT(SELECTCOLUMNS(Table1,"name1",Table1[field1])),DISTINCT(SELECTCOLUMNS(Table2,"name2",Table2[field2])))

 

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-xicai 

TYPO.

That shold be clients.

The question is really, how to use/relate a measure in a table.

ThankS

A