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

[Anonymous]

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"

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.

[Anonymous]

I just realised my DAX Query wasn't added to the post. I had to mask a lot of these tables.