Forum Discussion

DrewSmith's avatar
DrewSmith
Helper III
3 years ago

Matrix - Each row different calculation

I'm trying to make a PowerBI Matrix where each row is a different calculation. Below is what I would do if it was in Excel.

 

How can I do individual calculated rows in PowerBI Matrix?

 

 

1 Reply

  • You can use Field Parameters to acheive what you are looking for. I would start with this document from Microsoft.

     

    There is a second way to do it that is much more involved, involving creating tables and measures to select values based on a given row. But I would first start with Field Parameters and only move into more advanced ways once you understand those basics. 

     

    If this post was helpful, please kudos or accept the answer as a solution.
    ~ Anthony Genovese
    Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!