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.
Hello,
I have a data model in Power BI. I am having an issue that I have zero clue how to debug. I'm trying to figure out why a few of my measures (in this example, Mileage (Avg) ) do not match the source data. The calculation is a weighted average below:
Where are the other numbers coming from (158,100 and 4,100)? What could possibly cause this issue?
Solved! Go to Solution.
Hey @rawiswarden ,
without having the data, it's almost impossible to guess where the data is coming from (at least for me), but I'm pretty sure that Power BI does not "invent" data.
Besides that, I would recommend to re-write the measure like this, as it iterates across the table Facts_PortStats just once:
Mileage (Avg) =
sumx(
Facts_PortStats
, calculate(
divide(
Facts_PortStats[PortStats.Mileage]
* Facts_PortStats[PortStats.DiscountedLoanAmount]
/ Facts_PortStats[PortStats.DiscountedLoanAmount]
)
, userelationship(Facts_PortStats[PortStats.BookedDate], Calendar_Dates[Date])
)
)
But maybe this is already some kind of solution.
Regards,
Tom
Hey @rawiswarden ,
without having the data, it's almost impossible to guess where the data is coming from (at least for me), but I'm pretty sure that Power BI does not "invent" data.
Besides that, I would recommend to re-write the measure like this, as it iterates across the table Facts_PortStats just once:
Mileage (Avg) =
sumx(
Facts_PortStats
, calculate(
divide(
Facts_PortStats[PortStats.Mileage]
* Facts_PortStats[PortStats.DiscountedLoanAmount]
/ Facts_PortStats[PortStats.DiscountedLoanAmount]
)
, userelationship(Facts_PortStats[PortStats.BookedDate], Calendar_Dates[Date])
)
)
But maybe this is already some kind of solution.
Regards,
Tom
Thanks for the tip! I will use it.
I decided to roll back Power BI file to an older version and the issue is gone away. I don't know what happened, but a few buggy things happened in my file (M query statements that have worked for months started to fail on refresh, the data mapping was all incorrect for all but a subset of accounts). Now my file is back to showing the correct data .
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |