Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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
Proud to be a PBI Community Champion
Here are some exmaples.
Here are some exmaples.
@sabeensp You just create a measure with total as below and then use the option "Show value as "
Test120 = SUM(Test120Measure[Trans])
Proud to be a PBI Community Champion
I tried that, but when I select cutomer from the filter, it shows 100%.
@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
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |