Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
StinkyBO
New Member

Creating 2 measure one with slicer filter applied one without

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

1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

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.

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

Anonymous
Not applicable

Can you provide PBI file or screenshot.

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.

 

BD2E51AD-3844-4E1B-AE39-8D242E04CDAE.jpeg

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.