Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

cummulative value without affected by slicer

Hello There I need some help with my report. i have two tables in excel which is as my source of my BI report. one contain dates, monthly achievement, running cummulative monthly achievement, mon...
"DAX"
"FILTER"
Create Combo Chart
Filtered table
Help with Slicer.
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

i think it is hard to resolve this, if the x-axis value and the slicer value both come from date table.

if not, can try to remove the filters of slicers in the line measure.

=CALCULATE([Target Value],REMOVEFILTER(Slicers[Month]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    thanks, after two months the result is i have to build separate tables and it worked