Forum Discussion
Average with DAX
Hi, I have this data set: I want to create a bar chart, with Phase as category, like this: I need to have Role and Date filters on the dashboard. What I want to achieve is...
I have found the solution for my problem.
Sum of Flag = CALCULATE
(SUMX
(SUMMARIZE(Table, Table[Name], "Average", AVERAGE(Table[Flag])),[Average])
,Table[Flag] =1 )