Activating Date slicer by USERELATIONSHIP function

[Anonymous]

Hello!

In my fact table I have two date columns; creation_dateTime and Delivery_dateTime.

In need to use two date slicers in my report for both date columns. 

The Delivery_dateTime column has non active relationship with my dim_date table. 

How can I activate the Delivery_DateTime column and to use it in a  licer and to filter all report?

I created this query but it didn't work.

Delivery_Date =

CALCULATE(DISTINCT(Fact_Orders[od_Delivery_DateTime]),USERELATIONSHIP(Fact_Orders[od_Delivery_DateTime],Dim_Dates[Date]))

Any suggestions?

Thanks in advance!

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Try measure as:

Delivery = 
CALCULATE (
    DISTINCT(Fact_Orders[od_Delivery_DateTime]),
    ALLSELECTED ( Dim_Dates[Date] ),
    USERELATIONSHIP(Fact_Orders[od_Delivery_DateTime],Dim_Dates[Date])
)

 You can also refer this related post:

https://community.powerbi.com/t5/Desktop/Comparar-Per%C3%ADodos-Distintos/td-p/2024811

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[parry2k]

@Anonymous if you want two date slicers, you need to have another date table in your model which has a relationship with the delivery date. Userelationship function is useful when you have a single slicer and want to visualize data on both on creation date and delivery date.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡