Forum Discussion
Incorrect total in measure with division
Hi Anonymous ,
It is suggested to use HASONEVALUE.
You may try to create a measure to replace the TOTAL value.
%Meta=
IF(HASONEVALUE('Dados'[Classificacao]),[% Valores de Meta],[Resultado column sum divided by Meta column sum])
The HASONEVALUE is to perform a calculation in the row of the matrix to get the result1, and perform another calculation in the Total row to get the result2.
I can’t understand the language in your picture. If there is an error, please understand.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The issue was resolved with this link Solved: Re: Divide with error in total - Measure - Microsoft Power BI Community
Hi Anonymous ,
It is suggested to use HASONEVALUE.
You may try to create a measure to replace the TOTAL value.
%Meta=
IF(HASONEVALUE('Dados'[Classificacao]),[% Valores de Meta],[Resultado column sum divided by Meta column sum])
The HASONEVALUE is to perform a calculation in the row of the matrix to get the result1, and perform another calculation in the Total row to get the result2.
I can’t understand the language in your picture. If there is an error, please understand.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.