Dear community, Do you have any solution how can we show column total but should be on % of 100%. I have this solution : but i would like to change it like this , so total of subcategory should be 100% (calculation in blue are totally random just to show my expectaion : correct is 16,12% for 2,3% , 4,8% for 0,69% etc) More information : Using MatrixIn rows i have 2 categories : 1st general category 2nd : Revenue bandsvalue is sum of revenue Thank you in advance

SpiroswayGR , With % of sub total and % of total and isinscope you have try measures like ST % = divide([revenue], calculate([revenue], removefilter('Table', 'Table'[Revenue bands]))) % Total = divide([revenue], calculate([revenue], All('Table')) Final= If(isinscope('Table'[Revenue bands]), [ST % ], [% Total]) https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/ Refer for % of total and Sub Total https://youtu.be/6jTildcV2ho

amitchandak Thank you very much for your time.Total revenue is calculated column but i created a simple measure like this Total_revenue_Net_agg = sum(Reservations_Agreegation[Total_Charge_Net])ST % = DIVIDE([Total_revenue_Net_agg],calculate([Total_revenue_Net_agg], REMOVEFILTERS(Reservations_Agreegation, Reservations_Agreegation[Revenue_Band_Net]))) But i have below problem : Multiple table arguments are not allowed in the all / remove filters etc

SpiroswayGR , Try like , see if that work ST % = DIVIDE([Total_revenue_Net_agg],calculate([Total_revenue_Net_agg], REMOVEFILTERS(Reservations_Agreegation[Revenue_Band_Net]))) or ST % = DIVIDE([Total_revenue_Net_agg],calculate([Total_revenue_Net_agg], all(Reservations_Agreegation[Revenue_Band_Net]))) or ST % = DIVIDE([Total_revenue_Net_agg],calculate([Total_revenue_Net_agg], allselected(Reservations_Agreegation[Revenue_Band_Net])))

amitchandak I dont have error for them so i applied one by one but i have the same results ST % = DIVIDE([Total_revenue_Net_agg],calculate([Total_revenue_Net_agg], allselected(Reservations_Agreegation[Revenue_Band_Net])))% Total = divide([Total_revenue_Net_agg], calculate([Total_revenue_Net_agg], All('Reservations_Agreegation')))Final = If(isinscope(Reservations_Agreegation[Revenue_Band_Net]), [ST %], [% Total]) I think the problem is on ST % measure that calculate 100% for each one instead of correct one.

Any other idea how to solve this problem ?

Column Total but 100% | Microsoft Fabric Community

Forum Discussion

66 Replies

Related content