Forum Discussion
Balance sheet using matrix
i am preparing balance sheet using matrix, all rows comes from data table. i stuck when i want to add profit for the year in UNAPPROPRIATED PROFIT (Which is calculated with the help of dax.) how can ...
uzuntasgokberk
Super User
Super UserHello atifkazmi1980,
İf you are using matrix visualization in Power BI. There are rows, columns and Values in Format Pane.
And your measure "UNAPPROPRIATED PROFIT" can be used only in values. Because measure can be only used on Values. But if you created Calculated column you can use on rows and column. However, it will be shown without aggregated.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |