Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Percent of Column

Hello,   Being new to PBI, it is hard for me but maybe not for you.   I need to find out % of total. In one table I have Customers and Transactions Cust ------- Transaction A            ...
Need Help
sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago

I tried that, but when I select cutomer from the filter, it shows 100%.

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

sabeensp Oh ok !! Then, update the measure logic as below (And Don't use "show value as" option for this)

 

Test120 = 
VAR _Total = CALCULATE(SUM(Test120Measure[Trans]),ALL(Test120Measure))
VAR _CustTotal = SUM(Test120Measure[Trans])/_Total
return _CustTotal