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 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!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |