Forum Discussion
Blank Column with when using calculate
Hi there Just starting my power BI journey so I apologise if this has come up before I am working through some tasks and learning DAX functions the task is to use the calculate function
Again, from Home, click on New column, and type the following (the expression will be evaluated based on the filter ‘Europe’):
European Sales = CALCULATE (FactInternetSales [TotalSales], DimSalesTerritor[SalesTerritoryGroup] = "Europe")
The Total sale is a measure that was calculated in the previous step. When I input this the next step the columns is created but everything is blank and I am unsure what I have done wrong
NicOlds , if total sales is measure, then this should be measure too
European Sales = CALCULATE ([TotalSales], DimSalesTerritor[SalesTerritoryGroup] = "Europe")
or
European Sales = CALCULATE ([TotalSales],filter(DimSalesTerritor DimSalesTerritor[SalesTerritoryGroup] = "Europe") )
2 Replies
- amitchandakSuper User
NicOlds , if total sales is measure, then this should be measure too
European Sales = CALCULATE ([TotalSales], DimSalesTerritor[SalesTerritoryGroup] = "Europe")
or
European Sales = CALCULATE ([TotalSales],filter(DimSalesTerritor DimSalesTerritor[SalesTerritoryGroup] = "Europe") )
- NicOldsNew Member
Thank you for your help with this one seems so obvious now