Forum Discussion

johankent30's avatar
johankent30
Helper I
7 years ago

Measure Filter Help

I have the following measure: Measure 2 = IF(MAX(Collections1[Subcategory])="Sales Orders",'Sales Orders'[Sales Orders Value], IF(MAX(Collections1[Subcategory])="Purchase Orders",'Purchase Orders'...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

johankent30 can you share how you tables are related?

  • johankent30's avatar
    johankent30
    Helper I
    7 years ago
    parry2k right now there is now relationship. I’m not opposed to creating one. If I did it would be a many to one relationship from the collections1 table to the date table
    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      johankent30 as best practice it will be easier to have relationship. 

      • johankent30's avatar
        johankent30
        Helper I
        7 years ago
        Okay, is it possible to filter the subcategory values by a date selected on the date table then? How would the DAX look in my formula?