topic Re: need measure not syncronised with calendar slicer in DAX Commands and Tips

need measure not syncronised with calendar slicer

bmz545 — Thu, 18 Apr 2024 10:50:55 GMT

hi all,

I created a report where we have number of tickets and number of requests created from these tickets. More requests can be created from a tciket and on different days. I created the measure, used instersect dax to connect requests came from the tickets and now have calendar slicer where I can filter tickets created ex on 1st of april but the requests measure should ignor calendar slicer, as request can be created on later days.

edit: here is my measure:

digital requests for tickets =

VAR _ticketswithdigitalrequests
CALCULATETABLE (
VALUES (f_request[ticket]
FILTER (f_request, f_request[nb_created_digital] <> 0),
)

VAR _digitalticket
CALCULATETABLE (
VALUES (f_ticket [ticket_id]),
FILTER ( f_ticket, f_ticket [is_eligible]= TRUE ( ) ),
FILTER (d_channel, d_channel [digital] = TEUE ( ) ),

RETURN
COUNTROWS ( INTERSECT ( _digitalticket, _ticketswithdigitalrequests ) ) + 0

- in the table I have number of tickets and number of request measures, only number of requests measure should ignore the calendar slicer

how it can be done?

thanks in advance and have a nice day ahead.

Re: need measure not syncronised with calendar slicer

AnalyticPulse — Thu, 18 Apr 2024 10:02:06 GMT

use edit interaction feature to achieve this. and turn of interaction of the visual with other visual

My blog:
https://analyticpulse.blogspot.com/

https://analyticpulse.blogspot.com/2024/04/case-study-powerbi-dashboard-developer.html

See my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/

Re: need measure not syncronised with calendar slicer

bmz545 — Thu, 18 Apr 2024 10:56:15 GMT

thanks for your reply, I already edited the original message. I have 2 measures in the table and I want only one of them to ignore the calendar slicer.

Re: need measure not syncronised with calendar slicer

Anonymous — Mon, 22 Apr 2024 06:16:00 GMT

Hi bmz545 ,

You can try to use the HASONEVALUE function, you can refer to:HASONEVALUE function (DAX) - DAX | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

Re: need measure not syncronised with calendar slicer

bmz545 — Wed, 24 Apr 2024 15:09:48 GMT

VAR _ticketswithdigitalrequests
CALCULATETABLE (
VALUES (f_request[ticket]
FILTER (ALL(f_request), f_request[nb_created_digital] <> 0),
)

Added ALL after the Filter and it fied the issue

Re: need measure not syncronised with calendar slicer

bmz545 — Wed, 24 Apr 2024 15:10:56 GMT

Thanks for your reply. Seems ALL measure was the answer for that task.