Forum Discussion
DIACHROMA
Helper II
5 years agoCumulative measures with SELECTEDVALUE
Hello everyone ! I have three tables where different types of sales are calculated: drive sales, online sales, and in-store sales. I cannot put all of these sales in the same table because they ...
- 5 years ago
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
camargos88
Community Champion
5 years ago