Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated Measure's values into a slicer/report filter?

I have calculated measures and wanting to use that for a slicer/report filter.   I have two calculated measures "Best", "Next Best",  (Calculated measures solution: Solved: Re: Create new columns ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    All measures are in the attached pbix file's keymeasures field.

     

     

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

All measures are in the attached pbix file's keymeasures field.

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This gave me a good idea to create my own table with the measure values and the IDs and it worked! thanks so much 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    awesome, will check this out.thank you!!  Quick question: Your "Data" table has all the values in one table. For my case, all the values come from different tables so I don't really have a central table with Merchant ID + values (revenues). Do you think that makes a difference? 

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Thank you for your message.

      I am not 100% sure how your data model looks like, but if data model looks different, in some cases (I think in most cases), differnt measures have to be written.