cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

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

Top Solution Authors