Aggregate Measure

[devesqdeves]

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

HC FAC Billing Ano = CALCULATE(DISTINCTCOUNT(BI_HC_FAC_Count[ConsultantId]))

here is a example

https://1drv.ms/u/s!AhUegHSqFhOdmx8cNG9a-lFaC5EA?e=Oxsadz

[themistoklis]

@devesqdeves 

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

[devesqdeves]

@themistoklis 

How so ? i tried to do that but i only get repeated values and cannot aggregate the values :s

[v-xuding-msft]

Hi @devesqdeves ,

Can you please share more details? Which table is BI_HC_FAC_Count? And how is ConsultantId like?

[devesqdeves]

@v-xuding-msft 

@themistoklis 

@MFelix 

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..

https://1drv.ms/u/s!AhUegHSqFhOdmx8cNG9a-lFaC5EA?e=Oxsadz

[devesqdeves]

@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

[themistoklis]

@devesqdeves 

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