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

 

A quick question: How do you check how many equipments there is pr. inspectionID ?

 

An idea could be to have duplicates in your location table and then just insert inspectionID in that table. Then you could simply count amount of locations pr. inspectionID. Does that make sense?

 

Best,

Martin

Lilia's avatar
Lilia
Helper I
9 years ago

Hi Anonymous

 

 

Could you please give me a comprehensive explanation what I should do, when you are saying"have duplicates in your location table and then just insert inspectionID in that table. Then you could simply count amount of locations pr. inspectionID. "

And Dates table contains the key indicators Location ID and Inspection ID. And then I could not connect Location table and Inspection table because there is no anything common in them. In  Location table, I have Location ID but the same is missing in inspection table.


BR