Forum Discussion
Helper IVPercent 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 1
B 1
C 1
D 1
A 1
A 1
I've created a meesure COUNT(Transactions) which comes to 6
I have a filter, which allows user to select Cust.
I need to find out the % of Transactions by selected Cust. so If user select CUST A the 3/6 and etc.
Appreciate your help.
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
Here are some exmaples.
4 Replies
- PattemManohar
Community Champion
sabeensp You just create a measure with total as below and then use the option "Show value as "
Test120 = SUM(Test120Measure[Trans])
sabeenspI tried that, but when I select cutomer from the filter, it shows 100%.
- PattemManohar
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
- v-chuncz-msft
Community Support
Here are some exmaples.