Forum Discussion
Rbakker888
Helper II
Helper IIMultiplying 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.
rajendraongole1
Super User
Super UserHi 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.
Rbakker888Helper II
Helper IIEnded up fixing my semantic model due to being granted access to it. This formula works now, thank you!