Forum Discussion
sabeensp
Helper IV
7 years agoPercent 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 ...
- 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
- 7 years ago
Here are some exmaples.
v-chuncz-msft
Community Support
7 years ago
Here are some exmaples.