Not applying date slicer filter

[Digger]

I use calculated columns formula

_CountPay =

VAR thisOrderID = [order_id]

RETURN

COUNTROWS(

SUMMARIZE(

FILTER(

ALL(Table)

,Table[order_id] = thisOrderID

&& Table[type] in {"initial","upsell"}

)

,

[ID])

)

In visual matriix i use measure

_CountPayM =

SUMX (

SUMMARIZE ( Table, Table[_CountPay],Table[id])

,CALCULATE(MAX(Table[_CountPay]))

)

Table[created_at.1] relate to Calendar[Date]

So when i use Calendar[Date] in slicer and select one month, _CountPayM measure return same rezult as no date selected, but i need filter by selected slicer dates. How to fix that?

[v-easonf-msft]

Hi,  @Digger 

I did not find any problems with your formula.

In a card visual, will the value of _CountPayM be affected by the date slicer?

Please recheck your date table and the relationship between the tables. Make sure you use the correct table fields to create the matrix visual and slicer.

If possible , please share your sample file and expected result for further research.

Best Regards,
Community Support Team _ Eason