topic Re: Creating 2 measure one with slicer filter applied one without in DAX Commands and Tips

Creating 2 measure one with slicer filter applied one without

StinkyBO — Fri, 12 Aug 2022 11:19:02 GMT

Hi seniors,

i am stuck with this calculation for hours,

i am trying to calculate 2 average with same table but 1 ignore the filter and 1 with the slicer filter.

Measure A average = calculate result 1000 without slicer filter

Measure B average = calculate result 500 with the slicer filter

Measure C = then i would find the difference % by using divide B, A

thank you in advanc for the tips and solution

Re: Creating 2 measure one with slicer filter applied one without

Anonymous — Fri, 12 Aug 2022 12:16:36 GMT

Can you provide PBI file or screenshot.

Re: Creating 2 measure one with slicer filter applied one without

StinkyBO — Fri, 12 Aug 2022 12:29:38 GMT

I want to divide 170 to 3868 but dont know how to create the measure 1 with a filter 1 without, end up getting 100%, 3868/3868.

Re: Creating 2 measure one with slicer filter applied one without

Anonymous — Fri, 12 Aug 2022 12:31:41 GMT

If you want to display them seprate you can just disable edit interactions with slicer.

Re: Creating 2 measure one with slicer filter applied one without

StinkyBO — Fri, 12 Aug 2022 12:37:50 GMT

I know that, the problem is the measure to get 3868 without impacted by the filter selection, like using unfilter? Or ignore filter. Or selectedvalue.

Re: Creating 2 measure one with slicer filter applied one without

StinkyBO — Fri, 12 Aug 2022 12:42:28 GMT

Nvm i found it, using removefilters, table col name on the filter