Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago

Measure for different measures?

Hello everybody, got 5 different measures in 5 different tables.  Table1, measure A Table 2, measure B   Table 3, measure C Table 4, measure D Table 5, measure E   all measures return a value...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi franorio

 

You can create additional relationshships between DimAreas and MovementsReport, only they will be Inactive (or dotted lines).

 

What this means is measures will use the Active relationship by default, but you can use the USERELATIONSHIP function in your DAX meaures when you want to specify an alternative relationship.  

 

Does that make sence?

 

 

 

franorio's avatar
franorio
Helper III
9 years ago

Many thanks Phil_Seamark!

 

I created the dotted relationship between my Column Area of my DIMAreas and he column Area of my MovementsReport Table,. but i'm not sure how the forumla should look like..

 

Count of sumar cf = CALCULATE
COUNTROWS('MovementsReport')
FILTER(
'MovementsReport',
NOT ISBLANK('MovementsReport'[Sumar CF a]), USERELATIONSHIP(DimAreas[Área],MovementsReport[Area])
)
)

 

Tried this out, but it's not working