Forum Discussion
Solved
Multiplying based on category
I think I might be overlooking something simple here but I want to multiply my total revenue by x10 if the category of that order is "contract" This is what I currently use but while this work...
Hi Rbakker888 - check the below modified measure:
Total_Revenue_Adjusted =
SUMX(
Fact_Orders,
IF(
Fact_Orders[OrderCategory] = "Contract",
Fact_Orders[OrderRevenue] * 10,
Fact_Orders[OrderRevenue]
)
)Hope this works.
Rbakker888 , Try using
Order Marge Bedrag Multiplied =
IF (
fact_Orders[Artikel Categorie] = "Contract",
fact_Orders[Order Marge Bedrag €] * 10,
fact_Orders[Order Marge Bedrag €]
)
This doesnt work due to the [artikel Catergorie] being a column connected from a semantic model, so I cannot reference to it when using this query.
