How to Card visual relate with Day only not relate Month?

[porjaiko]

How to Card visual relate with Day only not relate Month

If select Month, It's show data 'blank'

and If select Day, It's show data per Day

follow this pic:

Thank you

[Icey · Accepted solution]

Hi @porjaiko ,

How about this:

Sum Value = IF(ISFILTERED('Table'[Month]),BLANK(),SUM('Table'[Value]))

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@porjaiko 

You can have a visual level filter. You can create a measure.

Date wise = var _max = maxx(Date,Date[Date])

return

calculate(Sum(Table[value]), filter(all(Date),Date[Date]=_max))