cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Re: Calculation issue due to interaction

Hello @v-ljerr-msft 

 

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 kind help.

 

Kind regards.

 

Andrej

 

Highlighted
Microsoft
Microsoft

Re: Calculation issue due to interaction

Hi @AndrejZitnay,

 

Thanks for the detailed explanation. Now I understand it totally. And I believe it you can use ALL or ALLExcept function to get the expected result in this scenario. However, without the sample data for testing, it's hard to provide a tested and correct formula for you. So could you try the formula below to see if it works? Smiley Happy

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

Regards

View solution in original post

Highlighted
Helper V
Helper V

Re: Calculation issue due to interaction

Hello @v-ljerr-msft

 

OMG!!!

You are star.

 

Now my measure works perfectly!!!

 

Thank you very much.

 

Kind regards.

 

Andrej

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors