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