Forum Discussion

mnb_dk's avatar
mnb_dk
Icon for Helper I rankHelper I
3 years ago

How to create a "reference table" fo use as filter?

Hi I often need to limit a report to only show values for specific product numbers. Until now I have used DAX and made a calculation, however I'm not sure this is best-practice. Especially not if i...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

You don't need to create relationships in this case.

  • mnb_dk's avatar
    mnb_dk
    Icon for Helper I rankHelper I
    3 years ago

    Hi

    I followed the steps you provided above by insterting a table and changed the DAX measure. It works.

     

    However, when I click on the graph that contains sales orders from the specific product numbers, the other visuals don't change/filter. How come?