Incorrect total in measure with division

[Anonymous]

Hello,

I have a table,

and the % Meta column is totaling incorrect. The correct thing would be

The measure is defined below

I need the total to be correct whith the totals as well. Line by line is already correct.

Thanks in advance.

[v-stephen-msft · Accepted solution]

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.

[Syndicate_Admin · Accepted solution]

The issue was resolved with this link Solved: Re: Divide with error in total - Measure - Microsoft Power BI Community

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

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.

[Anonymous]

For the Meta column, here are the details.

The Resultado column has the natural data of the base.

I need to divide the result column by Meta, with that Meta I only need one record, because they are all repeated.

There are no more measures involved.

[littlemojopuppy]

Can you provide the DAX for all the measures you're using?  Maybe a little sample data to cut and paste as well?

[Anonymous]

Hi @amitchandak,,

Below is the result.

[amitchandak]

@Anonymous , Try AverageX in place of SUMX and check

[Anonymous]

The field for MIN is the same on all lines.

Below is the result.

[littlemojopuppy]

It's calculating the MIN value across the entire table and using that as the denominator.

Instead try SUMX( TableName, MIN([FieldName]))

[Anonymous]

Thanks for the reply. When I do this it happens

[littlemojopuppy]

It's aggregating the percentages because you used SUMX in defining it.  Your measure should simply be DIVIDE([Numerator], [Denominator], BLANK() )