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

  • devesqdeves's avatar
    devesqdeves
    Helper II
    5 years ago

    themistoklis 

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

    • 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

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      5 years ago

      Hi devesqdeves ,

       

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

       

       

       

      • devesqdeves's avatar
        devesqdeves
        Helper II
        5 years ago

        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