Forum Discussion

Izzy's avatar
Izzy
Frequent Visitor
6 years ago

Replacing blank with average value in matrix visuals.

Hi guys, I am new in Power BI and trying to find a way to replace blank cells with average value in matrix visuals.  Then I can calculate the total prices and compare differents products. Here is ...
Need Help
  • Izzy's avatar
    Izzy
    Frequent Visitor
    6 years ago

    Hi v-eachen-msft,

     

    It looks close, but the last total is still a little questionable. The last row's sum is incorrect(40 + 30 + 20 + 78 + 52 != 245). I am blocked there. Any suggestions?   

     

  • Izzy's avatar
    Izzy
    Frequent Visitor
    6 years ago

    HI v-eachen-msft ,

    Any other Suggestions?

     

    Regards,

    Izzy