I have created the following 2 measures:
VAR AVERAGE_ = AVERAGEX(all(Data_shipments[Country]) ,[Success Rate new])
( IF ( HASONEVALUE(Data_shipments[Country]), [Success Rate new], AVERAGE_ ) )
I have "Country Name" in the row & "Product name" in the column. Using the above measure, I get the correct value for the average for "Success Rate" in the column total, but not at row level.
VAR AVERAGE_ = AVERAGEX(all(Data_shipments[Product Name]) ,[Success Rate new])
( IF ( HASONEVALUE(Data_shipments[Product Name]), [Success Rate new], AVERAGE_ ) )
Using the above measure, I get the correct value for the average for "Success Rate" in the row total, but not at the column level.
What modification did I need to do to get average of success rate at both column and row total? Please find attached screenshot for both cases.
Thanks in advance!
the issue looks like it is averaging all including blanks
if(not(isblank([Success Rate new])),
not(isblank([Success Rate new]))),
[Success Rate new]))
@Dnerada Thanks for your reply ,I am attaching screenshot for the reference ,will you please let me know what measure I need to right to calculate average % ,as % accuracy and % condition is coming from other measures.
Is there a chance you could send a sample of the data. Sometimes it's hard to help with out data to better understand how to help.
In matrix table it is not possible to have a average % in column subtotals ,row subtotal is working fine .Still you can workaround like make a seperate measures of % for each product and then make another measure of average of all products.But this meathod is static not dynamic .It worked in my case ,as products are static in my case .
Hope it helps..
Drop a comment if it helped..
You may have a look at below post and check if it helps. It's better if you could share some data which could reproduce your scenario and your desired output.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.