Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bmz545
Regular Visitor

need measure not syncronised with calendar slicer

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.

1 ACCEPTED SOLUTION
bmz545
Regular Visitor

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

View solution in original post

5 REPLIES 5
bmz545
Regular Visitor

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

AnalyticPulse
Impactful Individual
Impactful Individual

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

AnalyticPulse_0-1713434500136.png

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/

 

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.

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.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.