Forum Discussion

Digger's avatar
Digger
Post Patron
4 years ago

Not applying date slicer filter

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?


Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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