Forum Discussion

sg919's avatar
sg919
Frequent Visitor
3 years ago

Create a Performance Score based on Monthly Total AND Yearly Average

Hello PBI Community!  Novice PBI/DAX user here humbly seeking assistance. I'm trying to add a SCORING assessment for this KPI based on monthly date bins and yearly average score. I have several KPI...
DAX
DAX SWITCH
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Kudos for the detailed explanation. What you have in front of you is a nice introduction to filter context. Read about the different ways measures are calculated, read about aggregator functions like SUMX and then try stuff out.   One of the guiding principles in DAX  (especially for matrix visuals) is "Think like the Grand Total."  That way your measure can handle all scenarios.