In the first example the wrong % of tendy colors seems more right for me, because it always calculates % of all trendy colors among chosen in slicer and no matter what those trendy colors are. In a measure with keepfilters user can hardly guess what values he sees in the table. Vice versa the second usecase in video is an excellent example of using keepfilters formula - to apply both filters at the same time.
Hey there, For the new year sales use case - why would you define the measure specifically for a year? Wouldn’t a dynamic measure make a lot more sense? As in simply filtering for December and January? This way you‘d get new years sales for all years that will ever come.
Hi Marco.If we want a very simple cal like sales for product color red and show against a brand and I have slicer for color Then which option is right 1) Filter(values(color),color=red) 2) color = Red 3) keepfilters( color= Red) and what is best between 1& 3 option
Ciao Marco, I have a question regarding the New Year 2018 measure. I get that without KEEPFILTERS, the filter in CALCULATE will override the filter context of the year row, resulting in the same sales figures across the years. However, why is it not also the case for the month filter context, i.e. why does January 2019 shows 449,241.51, instead of 962,326.02?
Excellent representation. Thanks for all your hard work to the BI community.
Excellent examples and explanation of the proper use of KEEPFILTERS. Thank you!!
I use KEEPFILTERS very often for accounting measures, thx for the deeper insights
Briliant explenation!
Thank you Marco!
Extremely useful content, as always!!
Omg! This is well explained. Thank you so much
Thank you Marco
Very useful. Thank you very much.
Wow.Clear explanation...
Nice video and very good explanation.
like the new mark up pen. was helpful. thanks.
In the first example the wrong % of tendy colors seems more right for me, because it always calculates % of all trendy colors among chosen in slicer and no matter what those trendy colors are. In a measure with keepfilters user can hardly guess what values he sees in the table. Vice versa the second usecase in video is an excellent example of using keepfilters formula - to apply both filters at the same time.
I had the same thought. Always thought provoking content that's greatly appreciated.
Hey there,
For the new year sales use case - why would you define the measure specifically for a year?
Wouldn’t a dynamic measure make a lot more sense? As in simply filtering for December and January? This way you‘d get new years sales for all years that will ever come.
Hi Marco.If we want a very simple cal like sales for product color red and show against a brand and I have slicer for color
Then which option is right
1) Filter(values(color),color=red)
2) color = Red
3) keepfilters( color= Red) and what is best between 1& 3 option
Sales for Red Products =
CALCULATE(
SUM(Sales[Amount]),
keepfilters(Products[Color] = "Red")
Ciao Marco,
I have a question regarding the New Year 2018 measure. I get that without KEEPFILTERS, the filter in CALCULATE will override the filter context of the year row, resulting in the same sales figures across the years. However, why is it not also the case for the month filter context, i.e. why does January 2019 shows 449,241.51, instead of 962,326.02?
Ciao Marco!
In new year sales case you have used tuples, is there a way to feed tuples dynamically?
Any table expression that generate multiple columns, e.g. SUMMARIZE or CROSSJOIN
In USA, we'd use order of "red, white, and blue" :) because of our flag.