• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Wanted row wise calculation in Power BI matrix Table

D

DSP Varma

Member
Please remember to include links to any cross-posts
Hi All, I have attached a sample file with Raw Data and Summary sheets. In the Summary sheet, I have filled some cells with yellow color which I want in Power BI. I heard about the Averagex and Sumx formulae but I do not know how to you them. There might be some more slicers and conditions in the future. Can someone please help with the method on how to calculate in Power BI the yellow-filled cells in Power BI?
 

Attachments

  • Sample.xlsx
    28.8 KB · Views: 3
As you did on the other forum, please add here as well this is a cross-post. Thanks.

That's not a row wise formula in DAX. You can use DIVIDE function, referencing the other formula's.
Seems you have added manual rows "in" the pivot. I do not understand where these come from.
 

Attachments

  • Sample(2).xlsx
    179.3 KB · Views: 1
Last edited:
You must log in or register to reply here.
Back
Top