Forum Discussion

iLoatheMSDeep's avatar
iLoatheMSDeep
Regular Visitor
9 months ago
Solved

MAX function with FILTER and ALL

I have a situation where I would just like the actual field value shown in a measure.  I still need to do a calculation, but do not know how to proceed with performing the calculation on just the val...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    9 months ago

    Hi iLoatheMSDeep,

    Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome:

     


    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
9 months ago

Hi iLoatheMSDeep,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Jihwan_Kim, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:


I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

iLoatheMSDeep's avatar
iLoatheMSDeep
Regular Visitor
9 months ago

Thanks, but this still doesn't fit the scenario I described.  You have one field for previous month showing; I need to show the selected month data AND previous month at the same time.  This means I have to remove the date slicer filter from the Previous Month measure, and then apply my previous month filter to the Date field in order to get the last months values.  Again, the problem I am trying to solve is how to get the singular value for each row, and not the MAX for every item... 

For your measures, my question would be what is the syntax for removing the filter and adding a new one within a LOOKUP function?  Is that possible?

Thanks

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    9 months ago

    Hi iLoatheMSDeep,

    Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome:

     


    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      9 months ago

      Hi iLoatheMSDeep,

      Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

      Thank you.

      • v-kpoloju-msft's avatar
        v-kpoloju-msft
        Community Support
        9 months ago

        Hi iLoatheMSDeep,

        Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

        Thank you.