DAX Measure - Percentages are summed when not filtered

[Anonymous]

Hello,

I have this table:

I want to show the CVR in a chart. Problem is I found one formula working when filtered per platform, and one formula working when not filtered.

Working when filtered by platform:

Flat_File_CVR[ Orders ]/Flat_File_CVR[  Visits  ]

> Meaning that my percentages are summed when I don't filter, which is wrong.

Working when total only:

Flat_File_CVR[ Orders ]/CALCULATE(SUM(Flat_File_CVR[  Visits  ]);ALLEXCEPT(Flat_File_CVR;Flat_File_CVR[Months]))

Is there any way to have a formula working in both cases ?

Thanks.

[v-piga-msft]

Hi @Anonymous ,

By my tests based on your information, I'm not very clear about your requirement.

If it is convenient, could you share some data sample as table format and your desired output so that I can copy and test on it.

Best Regards,

Cherry

[Greg_Deckler]

Not 100% sure but, this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907