Forum Discussion
Aggregate Measure
Hey , everything good? I need a little help for this measure.. I have tried it all but i cannot find the solution to my problem , could u help me plz? These 2 tables are connected by the client id ...
Hi devesqdeves ,
Can you please share more details? Which table is BI_HC_FAC_Count? And how is ConsultantId like?
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..