Forum Discussion

VulcanPromance's avatar
VulcanPromance
Icon for Helper II rankHelper II
7 years ago

Creating a measure for Cost

I have this visualization   The cost license measure calculates price*count. However, I need an if statement to be able to calculate cost differently if the quantity type is pr license or tot...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey! First things first I'd advise you to use calculate(sum(.....)) instead of sumx(....) honestly it's easier to write and it performs better especially if you have larg(er) datasets. This should be more readeable:

 

sum(Calculate(1 * Price, Quantity_Type = "Total"), Calculate(Price * quantity, Quantity_Type <> "Total"))

or Calculate(1 * Price, Quantity_Type = "Total") + (Calculate(Price * quantity, Quantity_Type <> "Total")

 

Something like this should work I suppose.

  • VulcanPromance's avatar
    VulcanPromance
    Icon for Helper II rankHelper II
    7 years ago
    Cost_Licenses = CALCULATE(SUM([Count]*[Price])) does not work.
     
    Couldnt get it to work on your other two either
    Calculate(1 * Price, Quantity_Type = "Total") + (Calculate(Price * quantity, Quantity_Type <> "Total")
    Had to re-write them some, cause I assume I need the [] around the columns.. and I have no Quantity table. its in the license table
     
    So tried this.
    sum(Calculate(1 * [Price]; [Quantity_Type] = "Total"); Calculate([Price] * Licenses; [Quantity_Type] <> "Total"))
     
    It reports to many arguments in SUM
     
    Tried this
    Calculate(1 * [Price]; [Quantity_Type] = "Total") + Calculate([Price] * Licenses; [Quantity_Type] <> "Total")
    IT reports value of quantity type cannot be determined.