Forum Discussion
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"
Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.
2 Replies
- AnonymousNot applicable
I just realised my DAX Query wasn't added to the post. I had to mask a lot of these tables.
- v-chuncz-msftCommunity Support
Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.