Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.
@Anonymous
You may Use performance analyzer in Power BI Desktop to check query and take a look at SUMMARIZECOLUMNS.
I just realised my DAX Query wasn't added to the post. I had to mask a lot of these tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |