Part of total measure.

[BossCo]

Hi everyone!

I have got a column named "total sales" and another one called "sales on offer". I created a third calculated column "Sales not on offer" = Total sales - Sales on offer.

How I could show the total and filter them by offer/non offer using slicers or visuals? Is there a way?

Thanks a lot!

[v-juanli-msft · Accepted solution]

Hi @BossCo 

Create a slicer table with two rows"offer", "non offer",

Create a measure

Measure =
VAR non_offer =
    SUM ( 'Table'[sales] ) - SUM ( 'Table'[sales on offer] )
RETURN
    IF (
        SELECTEDVALUE ( 'slicer table'[slicer] ) = "offer",
        SUM ( 'Table'[sales on offer] ),
        non_offer
    )

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

xx

[BossCo]

Great, thanks a lot

[amitchandak]

You should able to create a filter

IF(isblank(sales on offer) ||  sales on offer=0, "Not on Offer","On Offer")

For rest please provide an example

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks. 

[BossCo]

Hi, I'm not able to do this because I have some records which are not blank both for offer and non offer. For Instance, a product that has been sold not on offer at the beginning of the day, and then on offer from a certain moment on.

Product      Sales        Sales on offer

A                 15€         0€

B                  6€          6€

C                  10€        4€

Thanks