Forum Discussion
Calculating a measure based on conditional result from another measure
Hello, I'm currently trying to set up a measure which works as follows. There is a measure which calculates the absolute change in the share within a market. So let's say you have country UK,...
After some more search I managed to find out how to get the total of the measure to not be zero, though the values were correct in a table:
m_Total 1 =
VAR __table = SUMMARIZE('Market',[Country],"__value",[Positive Absolute Share Growth])
RETURN
IF(HASONEVALUE(Market[Country]),[Positive Absolute Share Growth],SUMX(__table,[__value]))
Hope this helps anyone else with a similar question