Create Measure that shows monthly total under each day

[yiying]

Here is what my data look like now. I have been trying to create a new measure that for each day in December, it will show the same number 122251, which is the total. The number changes by month of course. Thanks!

[Zubair_Muhammad]

Hi @yiying

Try this MEASURE

Measure =
CALCULATE (
    [CountMeasure],
    FILTER (
        ALL ( TableName ),
        MONTH ( TableName[Dates] ) = MONTH ( SELECTEDVALUE ( TableName[Dates] ) )
            && YEAR ( TableName[Dates] ) = YEAR ( SELECTEDVALUE ( TableName[Dates] ) )
    )
)

[yiying]

Thank you so much it works!!

Another question. I also have a attribute "Type". When I add the filter , the new measure I created does not change. What should I do? 

[Zubair_Muhammad]

HI @yiying

Try Replacing ALL with ALLEXCEPT....

Check this revised code

Measure =
CALCULATE (
    [CountMeasure],
    FILTER (
        ALLEXCEPT ( TableName, TableName[Attribute] ),
        MONTH ( TableName[Dates] ) = MONTH ( SELECTEDVALUE ( TableName[Dates] ) )
            && YEAR ( TableName[Dates] ) = YEAR ( SELECTEDVALUE ( TableName[Dates] ) )
    )
)

[Zubair_Muhammad]

@yiying

Alternatively this should work as well

Just replace ALL(TableName) with All(TableName[Dates])

Measure =
CALCULATE (
    [CountMeasure],
    FILTER (
        ALL ( TableName[Dates] ),
        MONTH ( TableName[Dates] ) = MONTH ( SELECTEDVALUE ( TableName[Dates] ) )
            && YEAR ( TableName[Dates] ) = YEAR ( SELECTEDVALUE ( TableName[Dates] ) )
    )
)

[yiying]

Thank you! The allexcept works. But the on with all does not work for some reason.