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.
Power BI 101 question here. Need help getting the correct total to show in a column that is a measure.
Measure 1 = SUM(TABLE1 [Project_Actual])
Measure 2 (to get Measure 1 from previous month) =
Measure 3 = [Measure 2] - [Measure 1]
When I export out to Excel and SUM up the column, the total looks great for Measure 3.
But in my Power BI report, it is just taking the difference between Measure 1 Total and Measure 2 Total instead of summing the column. Again, probably very basic, but I can't seem to get it.
Any help would be greatly appreciated. Thank you.
Solved! Go to Solution.
I was able to fix this using the VALUES function you mentioned above, but just making a few changes. Thank you for the direction you gave me. I appreciate it.
@mkoontz
Can you try the following for Measure 3?
Measure 3 =
SUMX(
VALUES(dimDate[Period Rank]),
[Measure 2] - [Measure 1]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
Thank you for the quick reply. Unfortunately that did not work.
Some more details on the report layout.
Project Id (dimProject)
8 measures (including the 3 above) from 2 different Fact Tables with relationships setup back to dimProject
@mkoontz
Sharing a sample PBIX file will help understand the model.
You save it in google drive or one drive and share the link here.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I was able to fix this using the VALUES function you mentioned above, but just making a few changes. Thank you for the direction you gave me. I appreciate it.
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 |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |