Modify column Total by excluding a particular value

[NOVICE02]

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

[v-chenwuz-msft]

Hi @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 Regards

Community 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.

[amitchandak]

@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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc