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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AndrejZitnay
Post Patron
Post Patron

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.

 

 

 

Capture.JPG

 

Thanks

 

Andrej

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

Hi @AndrejZitnay,

 

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.

View solution in original post

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

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @AndrejZitnay,

 

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.

Hello @v-qiuyu-msft QiuyunYu,

 

Thank you for your respond.

 

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

 

Capture.JPG

 

Many thanks in advance for your help.

 

Kind regards.

 

Andrej

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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