Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I'd like to create a Measure that uses a filter which multiplies the gross cost for Bananas by 0.33, but keeps Apples and oranges at their full gross cost.
e.g. I grow the Apples and Oranges myself so keep 100% of the revenue, however my friend grows the bananas and I only get to keep 33% of the sale price.
How would you go about this?
Thanks in advance.
Solved! Go to Solution.
Hey,
using this measure
Gross Cost Adjusted = SUMX( VALUES(Table1[Fruit]) , var thisProduct = 'Table1'[Fruit] var thisFactor = IF(thisProduct = "Banana" , 0.33 , 1 ) return CALCULATE(SUM(Table1[Gross Cost]) * thisFactor ) )
allows me to create this table visual (and of course the measure will work with all the other visuals)
Hopefully this is what you are looking for.
Regards,
Tom
Hey,
using this measure
Gross Cost Adjusted = SUMX( VALUES(Table1[Fruit]) , var thisProduct = 'Table1'[Fruit] var thisFactor = IF(thisProduct = "Banana" , 0.33 , 1 ) return CALCULATE(SUM(Table1[Gross Cost]) * thisFactor ) )
allows me to create this table visual (and of course the measure will work with all the other visuals)
Hopefully this is what you are looking for.
Regards,
Tom
Thanks @TomMartens this works perfectly. You rock!
Now I better go get selling some more Apples, Oranges and Bananas...
🙂 an apple a day, ...
@TomMartens or if anyone else is listening... Can you please help extend this measure for me?
I would like to change my it now and have a different percentage based on a date.
e.g. My share of revenue was 33%, as demonstrated in the below measure. But as of 1 July 2019, I will now only get 25% for the bananas. How would I add in a time based line which calculates 33% pre-July, and 25% post July?
My column for the date is called MONTH.
Thank you!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
70 | |
67 |