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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I
Resolver I

userelationship measurement in visual

Dear all,

I want to create a measure in my date table which allows me to create visuals based on different definition when an order has been sold

Sales Date = CALCULATE(max(DIM_Date[Date])
                ,USERELATIONSHIP(DIM_Date[ID_Date],'FACT_Sales Amount and Conditions'[T_SD SalesDocuments.ID_SalesDate]))
Sales Document Date = CALCULATE(MAX(DIM_Date[Date]),
                            USERELATIONSHIP(DIM_Date[ID_Date],'FACT_Sales Amount and Conditions'[ID_SalesDocumentDate]))

This works like intended in a table visualisation, but not when I use e.g. a bar chart. I would rather not create a measure of the facts as I then should duplicate all the measures.



Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where you are stuck?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors