Forum Discussion

ahmadhatahet's avatar
ahmadhatahet
Icon for Helper I rankHelper I
6 years ago
Solved

Drill through overwrite calculate filter

 Hello Community.   I made a cumulative measure using calculate, all calendar and max date, very easy basic DAX.   When I drill through from page to page in Power BI desktop report this cumulati...
Need Help
Show and Tell
  • ahmadhatahet's avatar
    ahmadhatahet
    6 years ago

    I just went to the model and I don't know how but the cumulative works as it should.

     

    A great mystery to me.

     

    Thank you guys, really appreciate the efforts and the time ğŸ˜Š

ahmadhatahet's avatar
ahmadhatahet
Icon for Helper I rankHelper I
6 years ago

Thank you for your reply.

 

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ahmadhatahet ,

 

What is the relationship between your fact table and calendar table ?

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

  • ahmadhatahet's avatar
    ahmadhatahet
    Icon for Helper I rankHelper I
    6 years ago

    Calendar > Data (1 > *) [Date column as a key]

     

     

  • ahmadhatahet's avatar
    ahmadhatahet
    Icon for Helper I rankHelper I
    6 years ago

    Thank you for your reply.