cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NZCraig
Frequent Visitor

USERELATIONSHIP with a Table visualisation

Hi,

 

I have seen a few questions regarding USERELATIONSHIP and tables but not sure they quite answer what I am looking for. I have a measure that uses an inactive relationship between my date and fact table to get a count of orders due by week displayed in a stacked column chart.

I would like the use this chart to dynamically filter a table visualisation to show the corresponding order numbers and descriptions, however the table displays the orders using the active relationship, and so displays the wrong order numbers, as the active relations between the date and fact table is a different date range.

I can get the table to work by adding the measure as a column, but is it possible to do so without needing to add the extra column?

 

Many thanks in advance.

1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

You would need to use a measure in the to-be-filtered visual that also uses USERELATIONSHIP to get that behavior (either in the visual or in a measure used to filter that visual).

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Super User
Super User

You would need to use a measure in the to-be-filtered visual that also uses USERELATIONSHIP to get that behavior (either in the visual or in a measure used to filter that visual).

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Thanks @mahoneypat ,

 

Not sure if this is just a quirky thing or not, but by adding +0 to the end of my measure the table now seems to work as required without adding the column. However thanks for confirming that I might need to add the column if I still get get errors occuring.

Craig

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.