Forum Discussion
Create Measure or calculated Column for tabular Total
Is it possible to create a Measure or calculated Column that has a tabular Total?
If I create a Power BI table viz and enable Totals for that table, the Total is what I want as a as if it were an independent grouping that I can use in a viz or calculations.
The attached Excel mock up screenshot attached here illustrates what I am trying to get.
Any hints tips etc welcome and appreciated!
What you're asking for is not so easy to create. Alberto Ferrari has a vid on YT that deals with such issues. Basically, you have to create a different table with this row 'Category Total' added, connect this table to other table(s) and create a measure that will do the right thing. It's not basic stuff. If I find this video, I'll come back and give you a link. But you could try to locate it yourself on YT. Just try to search for phrases like "add total row", "add others"...
Here's something to get you started: Filtering the top products alongside the other products in Power BI - SQLBI
4 Replies
[Total Across Visible Categories] = CALCULATE( [Your Measure], ALLSELECTED( T[Category] ) )Thanks. That is interesting. But not what I am looking for.
Using the new measure you have lets me created the following yellow columns.
But I would like to add another category value that is the "Category Total" green row.
What you're asking for is not so easy to create. Alberto Ferrari has a vid on YT that deals with such issues. Basically, you have to create a different table with this row 'Category Total' added, connect this table to other table(s) and create a measure that will do the right thing. It's not basic stuff. If I find this video, I'll come back and give you a link. But you could try to locate it yourself on YT. Just try to search for phrases like "add total row", "add others"...
Here's something to get you started: Filtering the top products alongside the other products in Power BI - SQLBI
