Forum Discussion
Aggregate Measure
Best to Append the table in Power Query Editor and this will create a combined table. The use the dax formula in the combined table.
Or do a union of the 2 tables using DAX
On Union make sure you have the same number of columns
How so ? i tried to do that but i only get repeated values and cannot aggregate the values :s
After the union of the tables create a straight table add 'Main Client ID' and 'BI_HC_FAC_Count' columns..... and for the second column select SUM
Hi devesqdeves ,
Can you please share more details? Which table is BI_HC_FAC_Count? And how is ConsultantId like?
v-xuding-msftThe table BI_HC_FAC_Count IS the fact tables with all the records and one example of ConsultantId is 20DDB80-GG677J-988JJL
here it is , a example of my power bi with a copy of the data so that you can understant better.
I Have the mainclient id in the BI_HC_FAC_Count table , and i have the mainclientid and subclient id in client table, when i do the count , i need to count the subclient rows that are connected to a main client and sum them to the result of the main client as explained in this pbix file, but i am having a lot of difficulty doing so..
