Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |