Forum Discussion
Helper IICumulative measures with SELECTEDVALUE
Hi DIACHROMA
I think camargos88's suggestion is the best way to go. If you want to follow the approach you already had, you could do:
Measure = VAR selection_ = DISTINCT ( 'Selected Sales'[Selected Sales] ) RETURN ( "Drive sales" IN selection_ ) * [Sum of Drive sales] + ( "Online sales" IN selection_ ) * [Sum of Online sales] + ( "In-Store sales" IN selection_ ) * [Sum of In-Store sales]Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community ChampionHi DIACHROMA
I think camargos88's suggestion is the best way to go. If you want to follow the approach you already had, you could do:
Measure =
VAR selection_ =
DISTINCT ( 'Selected Sales'[Selected Sales] )
RETURN
( "Drive sales" IN selection_ ) * [Sum of Drive sales] +
( "Online sales" IN selection_ ) * [Sum of Online sales] +
( "In-Store sales" IN selection_ ) * [Sum of In-Store sales]
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Helper IIAh yeesss !! It works !! THANK YOU SOOO MUCH AlB !
camargos88 thanks for your help too ! I'm sorry I didn't understand your suggestion.. 😞
I don't have data as example and I'm affraid I can't send you the current one. But I'm curious to understand your solution so if you have any demo I'm all ears ! 🙂
Thank you both !
Pauline