Forum Discussion
Helper IICreating a measure for Cost
Solution SageHi VulcanPromance,
It seem like you have all 3 columns availeble in the same table, so why not just add your cost calculation as a calculated column instead of a measure? I am aware of the extra cost involved with calculated columns, but it's an easy fix and you would need a lot of data for this to have a mentionable performance penalty in this case.
Cost_Licenses =
IF(
Licenses[Quantity_Type] = "Total";
Licenses[Price];
Licenses[Price] * Licenses[Count]
)
Should also work as a measure like this:
Cost_Licenses_Meas = VAR CostTotal = CALCULATE( SUM(Licenses[Price] ); Licenses[Quantity_Type] = "Total" ) VAR CostPrLic = CALCULATE( SUMX( Licenses; Licenses[Price] * Licenses[Count] ); Licenses[Quantity_Type] <> "Total" ) RETURN CostTotal + CostPrLic
Helper IIHi 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
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
- VulcanPromance
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.