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.
Good morning,
I am trying to calculate a simple measure subtotal, but I am having problems doing so.
I have the following simple table:
I am trying to calculate the POND 1 and POND 2 %.
I am doing so applying the following formulas:
I am doing so by applying the formula:
When I try to calculate the new % over the product, it uses the red circled 1,00 as the denominator. I would need this behaviour:
2 / 25 ... 11 / 25 .... and so on.. but it is using 2 / 100 ... 11 / 100 ...
Thank you so much!
Solved! Go to Solution.
@mizaskun , Create a measure like
sumx(summarize(Table, Table[persona], table[Region], Table[RIEGO], "_1",[P1]*[P2]) , [_1])
@mizaskun , Create a measure like
sumx(summarize(Table, Table[persona], table[Region], Table[RIEGO], "_1",[P1]*[P2]) , [_1])
It works! Great! Thank you!
I need to calculate now the sum of the different P% that we have just calculated with your formula * the VAL field. I am trying something like:
Thank you so much!
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |