DIVIDE Measure by itself based on dynamic filter

[Anonymous]

 

Hi there,

I'm stuck in a calculation I don't know if it's even possible to make or not.

I'm trying to make the calculation so as to be like this one below:

Revenue % / Revenue %

But the numerator should be filtered by date interval and denominator should be filtered by anothee one.

Both filters will be dynamic filters in the dashboard itself.

Is there anyway I can make this calculation?

[harshnathani]

Hi @Anonymous ,

Not very clear.

Please share sample data and expected output.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

These 2 measures are the same but each one is affected by one of those date filter.

What I want is to create a new measure that take those two different values of the same measure and divide them to make the improvement KPI.

[pranit828]

Hi @Anonymous 

What is the formula you are using to get this two measures?

Are these two independent filter on the same date field?

[Anonymous]

Return Percentage = DIVIDE('Measure Home'[Return Volume Tones],[Net Volume])

Yes they're two separate filters on the same date field.

[v-deddai1-msft · Accepted solution]

Hello @MOHED1224 ,

You must create two equal tables. and create two same measures from the columns of these two tables. You can then filter the numerator and denominator in two filter contexts.

For more details, see my pbix sample: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EdvXkmy6JZZDsJUW2m...

If this post helps, then consider Accepting it as the solution to help other members find it more quickly.

Best regards

Dedmon Dai

[Anonymous]

It worked.

Thank you so much!

Your input paved the way to the solution.

[v-deddai1-msft]

Hi @Anonymous ,

I'm glad that your issue has been solved. Would you please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai