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.