Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding column from different table to fact table while using a measure isn't working properly

Hi there,  I'm new to power BI and I am having an issue when adding a column to a table linked my fact table while my caculated measure is being used. The measure works fine until I do this, and using this linked tables works fine until I use the measure.  I've searched around the last few days trying to solve it myself and trying to find a solution but am unable to find anything. Does anyone have a solution or can they point me in the right direction? 

 

edit:  The values that read "PId" should be PersonId and are not a PK. Person 1 and 2 are views if that helps.

The Dax Query is

Max Rank = VAR inMax =CALCULATE(MIN(MFact[Rank]), ALLEXCEPT((MFact),MFact[MId] ))

RETURN
IF(inMax= CALCULATE(MIN(MFact[Rank])),1,0 )

Thanks

It works when just using columns from MFactIt doesn't work properly when I add a column from "Person1" or "Person2"