Count Number of Times Measure is True in Selected Month

[patri0t82]

Hello, I have a Measure that I use in a Matrix that displays a checkmark on each day the result is 100%:

IF (
    CALCULATE (
        DISTINCTCOUNT ( MyTable[Name] ),
                MyTable[JobAbbr] <> "V" && 
                MyTable[JobAbbr] <> "T" && 
                MyTable[JobAbbr] <> "S" && 
                MyTable[JobAbbr] <> "P"
    ) / [Count-Jobs] = 1,
    "☑",
    ""
)

I would now like to count the number of times the checkmark appears in the selected month. (based on CalendarTable[Date])

[Greg_Deckler]

@patri0t82 This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[patri0t82 · Accepted solution]

I was able to solve the problem using this:

100%Compliant = 

SUMX (
    VALUES ( CalendarTable[Date] ),
    VAR MeasureValues = {
        [PreviousMeasure]
    }
    RETURN
        SUMX ( MeasureValues, INT ( [Value] = "☑" ) )
)

[patri0t82]

Thanks for the response. I have to admit, it's a little beyond me. I'm hoping to get a count, not a Min, Max or Average. 

Perhaps there's a solution I should be looking for in Power Query?