I have a matrix that needs to calculate an Average Premium. Basically $x / y = $avg x.
In my report I have:
I'm expecting to see Avg of
The dataset does have some NULLs when it's expanded for some rows so I am thnking this might be messing it up? Basically my avg calc looks like this:
AvgPremiumAct = (Query1[PremiumAct])/(Query1[CountAct]) and I have the summarization set to Average.
How do I get this to show correctly?
Thanks for all suggestions.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-... Please show the expected outcome based on the sample data you provided. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.