Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure dependent on slicer selection

Hi, in a scenario where the pieces of a product are being stressed in an oven over time I want to calculate the remaining capacity of the ovens during a selected calendar week. My tables are as f...
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to change the one-to-many relationship(single) marked by red circle below to both.

Hope this helps.

 

Best Regards,

Giotto

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-gizhi-msft 

I changed the relationship like you told me to but i don't see how this helps me. If you could elaborate on how this is beneficial to solving my problem I would be very grateful.

I am struggling with the DAX syntax for the measure.

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    According to your description, i think you want to filter 'Stressing' table by selecting week in 'Calendar' table.

    If so, you should change the filter direction from 'Calendar' to 'Stressing', this is why i advise changing the relationship direction.

     

    Best Regards,

    Giotto

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    Could you please share your pbix file by OneDrive for Business?

    This can let me help you further.

     

    Best Regards,

    Giotto

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Unfortunately I can't send you the file. Please correct me if I am wrong but I think your idea was to create a measure with the FILTER function which returns the filtered 'Stressing' table and this I could use to check if there are multiple ovens with the same name in this new table?

      I tried to implement this

      Measure = FILTER(Stressing;RELATED(Calendar[CalendarWeek]))
      It does not work though because the Calendar table is not handled as a related table to the Stressing table even though I changed both relationships Stressing <-> Stressing(referenced) and Stressing(referenced) <-> Calendar from single to both.

       

      Maybe it would be possible to filter the Stressing table by using the already implemented Calendar Week Slicer.

      v-gizhi-msft 

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Community Support
        6 years ago

        Hi,

         

        Any good progress?

         

        Best Regards,

        Giotto