Forum Discussion
Modify column Total by excluding a particular value
Hi all,
I don't think this can be done but just wanted to check....
Is there a way to have the volume of purchase out of the total ?
the values under the months depict the loss from the purchase. I force aggregated the total purchase in the column for visual sake and wondering if there is a way to show the total for the losses only. in the same view
2 Replies
NOVICE02 , if you are using two columns/measures in values you will see two totals
But using isinscope you can change the total
new measure= if(isinscope(Table[Month year]), [volume],[Purchase])
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcHi NOVICE02 ,
Is that you want to get total of losses purchase under the Total column?
If yes you can try some thing like this measure.
Measure = VAR _total = SUMX( FILTER( 'Table 2', [if_loss] = 0 ), [volume] ) VAR _total_loss = SUMX( FILTER( 'Table 2', [if_loss] = 1 ), [volume] ) RETURN IF( HASONEVALUE( 'Table 2'[Column month] ), _total, _total_loss )result:
If i misunderstood you please share some data without sensitive data and expect result.
Best RegardsCommunity Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
