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.
Hi,
assume I have two customers:
Customer A paid $100
Customer B paid $50
I would like to show top 1 customer by paymnet.
Choosing the correct filter I get
Customer Payment
A $100
Total $100
How can I show an extra column with % of total payment, equaling to 0.66 (100/150).
In other words - I would like to define a measure that is always equals to sum of both payments, regardless of the filter.
Thank you in advance,
Alex
Solved! Go to Solution.
Hey,
this measure creates what you are looking for
Payment vs Payment All = var currentPayment = CALCULATE(SUM('Table1'[Payment])) var AllPayment = CALCULATE(SUM('Table1'[Payment]),ALL('Table1'[Customer])) return DIVIDE(currentPayment, AllPayment, BLANK())
and a little screenshot:
Hopefully this provides what you are looking for.
Regards,
Tom
You can do it like this:
=DIVIDE( SUM( Data[Amount] ), CALCULATE( SUM( Data[Amount] ), ALL( Data[Customer] ) ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thank you both!
You can do it like this:
=DIVIDE( SUM( Data[Amount] ), CALCULATE( SUM( Data[Amount] ), ALL( Data[Customer] ) ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hey,
this measure creates what you are looking for
Payment vs Payment All = var currentPayment = CALCULATE(SUM('Table1'[Payment])) var AllPayment = CALCULATE(SUM('Table1'[Payment]),ALL('Table1'[Customer])) return DIVIDE(currentPayment, AllPayment, BLANK())
and a little screenshot:
Hopefully this provides what you are looking for.
Regards,
Tom
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |