Forum Discussion
Solved
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 ...
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") )
amitchandak
Super User
Super UserNicOlds , 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") )
Thank you for your help with this one seems so obvious now