Create a new conditional column

[sb14415]

I'm needing to create a new column/measurement based on a conditional count from other columns. The new column needsto be a count of how many months each row did not achieve a certain %. The columns being counted will change at the end of each month.

[JirkaZ · Accepted solution]

That shouldn't be too difficult. Something like this:

My Measure := 

SUMX(VALUES('DimDate'[Month]), IF(ActualAvgMeasure < TargetPct, 1, 0)) 

I hope you got the logic/approach. This assumes that the month granularity will be there in the visual at all times.