Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Enter calculated rows in visual Matrix

I need to insert a calculated row in a visual matrix, where this measure makes me the calculation of the data that is in the same visual.

For example;

"= Margin C" is the measure I would like to introduce, it would have to make the difference between the sale and the cost, or, any data I need to calculate.

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi, Syndicate_Admin 

    According to your description, you want to add a row above your visual, and then you need to ask for the difference and additive, for your needs, first you want to add a custom row on your visual, then you need to add the corresponding row in your table to display the row you defined in your visual.
    Second, if you interpolate and accumulate every two lines, you also need to be able to determine the line numbers for each row or your own classification settings, which is very complex and difficult to implement in Power BI.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly