Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX

Need help with DAX Let say I have two tables Table 1- Company Now Each company can have multiple assets Let say Company Assets C1 A1 C1 A2 C1 A3 C2 A1 C2 A2 and so on...... Now I have ano...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could use this formula:

    Measure =
CALCULATE (
    COUNT ( Resource[Resources] ),
    FILTER ( Resource, Resource[Assets] IN VALUES ( Company[Assets] ) )
)

     

    Best Regards,

    Jay

Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

When you say "Table 2- Resource and it is already joined using a primary key" what exactly do you mean? You mean it has a relationship with Table 1? Or with some other table?

Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes correct, It already has a relationship mapped by Project ID to Table 1.

All I am looking for is a DAX that can help me aggregate the columns present in Table 2 for Company Column Table 1

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Share the download link of your PBI file with the relationship already created.  Share dummy data if you wish to.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Definitely not feasible for me to share pbix file. However I have already shared the data format above with dummy data. Essentially I just want the count of resources for each company.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Hi,

        In neither table have you shown/shared the column which you have used for creating a relationship so i cannot help.