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.
Semana | Planejado | desvio | _desvio |
1 | 12300 | 3.000 | |
2 | 32900 | 1.650 | |
3 | 32200 | - 1.950 | - 1.950 |
4 | 27950 | 2.250 | |
5 | 32200 | - 12.558 | - 12.558 |
Total | - 7.608 | - 7.608 |
Do jeito que ela está, só consigo zerar os valores positivos, porém a soma do total ainda continua considerando os valores positivos.
Quem puder ajudar eu super agradeço!
Solved! Go to Solution.
Hi @telassime ,
You will need to create two measures.
negativos = IF(SUM('Table'[desvio])>=0,0,SUM('Table'[desvio]))
Measure = SUMX('Table',[negativos])
Result would be shown as below.
Best Regards,
Jay
Thanks for you reply!
The problem was solutioned 😉
Telassime, you welcome.
Please, select the anwser solution to finish the post.
Best regards.
Hi @telassime ,
You will need to create two measures.
negativos = IF(SUM('Table'[desvio])>=0,0,SUM('Table'[desvio]))
Measure = SUMX('Table',[negativos])
Result would be shown as below.
Best Regards,
Jay
Hi.
You can create two custom columns in dax separatelly, one for positives values and another by negatives and get your results.
Negative Values = IF(VALUE(Tabela[desvio])<0,BLANK(),VALUE(Tabela[desvio]))
Positive Values = IF(VALUE(Tabela[desvio])>0,BLANK(),VALUE(Tabela[desvio]))
Best Regards.
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |