Sum or Calculate in Measure?

[sakamotothais]

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

[technolog]

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.