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 guy's,
I need a help on power BI in a conditional sum.
I have 4 measurements that show:
- The amount of product
- If the product had an increase then 1 (100%) at the increased minus 0
- If the pod had no increase and no decrease then 1 (100%) not neutral
- If the product had a decrease then 1 (100%) at the minus minus 0
Reflect the table below
Now I need to count how many in total I have increased, in total I have decreased, and in total I have neutral.
I can not calculate a measure that does this.
After you calculate the total for each one, calculate the total percentage of the three.
Example:
Total of 22 in quantity
100/22 = 4.54%
Increased in the table I have 3 values with 100%
I want to make a measure 4.54 * 3 = 13.62%
and
Decreased in the table I have 16 values with 100%
I want to make a measure 4.54 * 16 = 72.64%
and
Neutral in the table I have 3 values with 100%
I want to make a measure 4.54 * 3 = 13.62%
Total sum = 13.62 + 72.64 + 13.62 = 100%
Any suggestion?
thanks
thanks
Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.
If not, it may make sense to ask the question again, thus confirming the relevance of this problem.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |