Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure based on slicer dates

Hi all, I need help in resolving a issue. There are 2 tables which are connected to each other with 1 to many relationship and a date table.   My tables refreshes every day. I am using a slicer to...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous think allexcept function overwrite the filter context comes from date table. try this code

Max_Status = calculate(Max(SCH[CO_ST]),ALLEXCEPT(SCH,SCH[ID]),values(dates[date]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     I guess I was not able to ask my question correctly. My requirement is if I select say 21st Oct on slicer, I will be able to get the status of the records for that day only and not as on yesterday. Records can have different status on different dates. Status should change based on slicer dates.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Anonymous , if it is connected with date that should happen.

      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.