Forum Discussion
paumeneses24
1 year agoNew Member
Problemas con total en Power Bi
Problemas con formula en Power BI. Realice una nueva medida con formula DAX simple en el cual necesito que que me tome el 10% en referencia a una columna en la cual existan saldos negativos, la cual...
Anonymous
1 year agoNot applicable
Thanks for the reply from edchuy.
Hi paumeneses24 ,
According to your problem description, it is a common phenomenon to have problems with total rows, when it is because in the total rows, the summation has already been done without performing IF condition judgment. As edchuy said, we can use SUMX, it will iterate through each row.
Here are my test results:
Descuento filtro 10% = SUMX('Table',IF('Table'[Saldo G.F.]<0,0,'Table'[Ingresos]*0.1))
The measure deserves the right result:
Best Regards,
Zhu
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.