mercredi 4 avril 2018

Incorrect column total in measure column with multiple IF() in Power BI

I have the mentioned issue in the following riport. All measure column totals are working incorrectly. These are the last three.

Riport

I have used that calculation DAX calculation_with_multiple_if.

Its working fine, but I have not got the correct column total as you can see below:

Incorrect_total_on_the_last_row

I have find some almost same issue, but I can not implement it to mine. Unfortunatelly, I can not provide the full riport due to the client agreement.

May I use SUMX,VALUES,SUMMARIZE?

Could anyone provide a solution please?

Aucun commentaire:

Enregistrer un commentaire