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
VulcanPromance's avatar
VulcanPromance
Icon for Helper II rankHelper II
7 years ago

Hi sdjensen 

All versions yield the same result.. maybe it wasnt too clear..

 

For quantity type Total the Cost_Licenses should be 482. Cause its an enterprise cost. I.e. Portal access costs 482Euro a month regardless of count.

 

But as you can see your Measure and your Column yields the same result as my Cost Licenses which does not contain an IF.

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
7 years ago

VulcanPromance,

 

This is very strange, because I created a table as manual input into Power BI and both worked in my case.

 

You are 100% sure that is just saying "Total" without exceeding or preceeding spaces etc.?

  • sdjensen's avatar
    sdjensen
    Icon for Solution Sage rankSolution Sage
    7 years ago

    VulcanPromance,

     

    Here is my result with calculation as column and measure

     

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

      sdjensen 

      Im very new to Power BI, but the column one kinda makes sense.. I created the column on the table. And for each license it puts on the price obviously.. So Price = CostColumn for each license in the table.

      Cost_Licenses = 
IF(
    Licenses[Quantity_Type] = "Total";
    Licenses[Price];
    Licenses[Price] * Licenses[Count]    
)

      I reckon it runs this code pr line/record and since a record = 1 count the price = cost

      So for each record that has a quantity type of Total it lists 482. When visualizing this column, it multiplies the numbers

       

      EDIT: Yes, I checked that Total does not have any space before or after.

      I'm suspecting this has something to do with how I set up the tables? I merged in prices, bundlename and quantity type from another table in power query.