cancel
Showing results for
Did you mean:
Highlighted
Helper V

## I need measure to ignore turned off interaction in Slicer

Hello All,

Can you help with my measure?

Renewals rate = [Renewals]/[Settlements]

I had to turn off interaction to Settlements and my calculation is not accurate.

Thanks

Andrej

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support

## Re: I need measure to ignore turned off interaction in Slicer

Based on my understanding, the Settlements won't be filtered by the slicer, and you want to return values filtered [Renewals] divided by not filtered [Settlements], right?

In your scenario, please modify the measure with ALL() function like below:

Renewals rate = [Renewals]/CALCULATE([Settlements],ALL(<your table name>))

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V

## Re: I need measure to ignore turned off interaction in Slicer

Hello @v-qiuyu-msft

I have now solution

Rate =
[Measure Renewals related]
/ CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )

Thank you very much anyway for your time.

Kind regards.

Andrej

3 REPLIES 3
Highlighted
Community Support

## Re: I need measure to ignore turned off interaction in Slicer

Based on my understanding, the Settlements won't be filtered by the slicer, and you want to return values filtered [Renewals] divided by not filtered [Settlements], right?

In your scenario, please modify the measure with ALL() function like below:

Renewals rate = [Renewals]/CALCULATE([Settlements],ALL(<your table name>))

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V

## Re: I need measure to ignore turned off interaction in Slicer

Hello @v-qiuyu-msft QiuyunYu,

I will try to make it more clear.

I have two date slicer on my measure.

1st Date of renewals which have all active interaction

2nd Retention Renwals which have one blocekd interaction as settlements shouldn't change.

Both Measures for Renewals & Settlements comes from excel tab A (symple count if formula)

Slicer Date of Renewals is Date table for excel tab A & excel tab B

Slicer Retention Periods is date from excel tab B

Kind regards.

Andrej

Highlighted
Helper V

## Re: I need measure to ignore turned off interaction in Slicer

Hello @v-qiuyu-msft

I have now solution

Rate =
[Measure Renewals related]
/ CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )

Thank you very much anyway for your time.

Kind regards.

Andrej

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors