Forum Discussion

Dayna's avatar
Dayna
Helper V
4 years ago
Solved

Filter values based on static value

Hello,   I suspect this is a fairly easy one, but I'm struggling to work out whether the measure should be a CALCULATE(), SUMMARIZETABLE() or something else...!   Basically, I have a table with a...
Need Help
  • Dayna's avatar
    Dayna
    4 years ago

    I refactored my tables and relationships to achieve it on a data level rather than within PowerBI. 

Dayna's avatar
Dayna
Helper V
4 years ago

My original use case was to use the value within the table alongside with other records, so I wasn't convinced that a visual filter would work... I'll see if I can change my approach a little, and perhaps link the charts to bookmarks to show different filtered views of the data based on the bookmark selected.

 

Thanks for the responses all, very much appreciate this forum!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Dayna ,

    Did you get a proper approach for your problem? If yes, could you please share it with us if it is convenient? Thank you.

    Best Regards

    • Dayna's avatar
      Dayna
      Helper V
      4 years ago

      I refactored my tables and relationships to achieve it on a data level rather than within PowerBI.