Forum Discussion

DIACHROMA's avatar
DIACHROMA
Icon for Helper II rankHelper II
5 years ago
Solved

Cumulative 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 ...
  • AlB's avatar
    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