Forum Discussion

devesqdeves's avatar
devesqdeves
Helper II
5 years ago

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

 

HC FAC Billing Ano = CALCULATE(DISTINCTCOUNT(BI_HC_FAC_Count[ConsultantId]))
 
here is a example

 

Need Help

6 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    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

      • themistoklis's avatar
        themistoklis
        Community Champion
        5 years ago

        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