Forum Discussion

Lilia's avatar
Lilia
Helper I
9 years ago

Calculate value based on unique values in different table

Hello all, I need of urgent help for some DAX calculation.  Here it is my case: I have three tables  you could see it below   You should know that item type = show the type of the item/ Equ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Lilia,

 

Can you please share some sample data to analysis and test?

 

Regards,

Xiaoxin Sheng

Lilia's avatar
Lilia
Helper I
9 years ago
  1.  Hello Anonymous


    Please find attached link to some sample data to analysis and test. https://1drv.ms/f/s!Av0-ISefEa7u4iMhcegcVqoiqiHA

    I would like to calculate how many pieces of equipment and locations I have per inspection id- display ID.
    Table content;
         In location table, I have a description of the location and of what item is behind this location id, is it equipment or location.
        In dates- I have location id and inspection id. Which inspection id, if it's connected to inspection table, will show the inspection number.
        In Inspection table, you could find an InspectioniD and Location ID.