Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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 )
xx
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 )
xx
Great, thanks a lot
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |