Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |