I would like to retrieve a text with the CALCULATE ( xxx, USERELATIONSHIP (xxx) ) formula.
I understand that USERELATIONSHIP must be used inside a CALCULATE function, but what I want to retrieve is just text only without any calculations.
Does anyone knows how to get the text from a CALCULATE function?
I have the same question. And I only find examples where they use the date/time in role playing dimension
I'm want to use role playing for an other purpose then role playing date's.
I have a FactSales table that contains 2 keys that describes the relation to a DimensionCustomer table. Let's see one is the ship-to-party(SHP) and the other one is the sold-to-party(SDP). So the fact table has two keys KeySHP and KeySDP.
I can create one active relation to the Customer Dimension and one inactive one.
Now I want to create to measures to be able to create a visual with:
Sales Amount; Ship-to-Party, Sold-to-Party
I assume I need to make two measure to be able to use Ship-to-Party and Sold-to-Party and I believe it should look like:
Ship-to-Party = Calculate(Max(DimensionCustomer[Ship-to-Party]), USERELATIONSHIP(DimensionCustomer[KeySHP], FactSales[KeySHP])
Is it correct to use role playing dimensions in this way?
Here is an example.
Column 1: TableID
Column 2: POLCountryName
Column 1: POLCountryName
Column 2: Count_POLCountry
I want to create a MEASURE to retrieve the POLCountryName from the ChildTable so that the POLCountryName can be displayed into a map (using MapBox plug-in) as a Tooltip.
Since my data must be linked by USERELATIONSHIP function, I cannot simply drag & drop POLCountryName from the MotherTable into the tooltip of the map because it doesn't give me the correct result.
In addition, the map tooltip only allow to display AGGREGRATE function (first / last / count distinct / count) and there is no option for "Don't summarize" as it doesn't appear in the right click option, so I tried to create a ChildTable and see whether I can use CALCULATE (xxx , USERELATIONSHIP (xxx) ) to retrieve the POLCountryName from the ChildTable.
Is there any other ways that can help me to display the correct POLCountryName in the map in consideration of the USERELATIONSHIP?
Does this work?
=CALCULATE(VALUES('Master Table'[PolCountryName]),USERELATIONSHIP('Child Table', ))
No, it didn't work and not able to display what I need.
This formula only works at modelling level, but not at visual level.
In addition, if I pull this new measure into the tooltip of MapBox, the tooltip still limits to the aggregate functions only (first / last / count distinct /count).
So you mean that you get the correct answer with my formula when you drag my formula to a Table visual, but not when you drag it to the tool tip section. Am i correct?
That is very strange. Sorry i do not know why that is happening.
Hi I have a similar problem with using USERRELATIONSHIP with text columns. Trying to match online comments with locations, and tehre is already a connection with Date Table. So I use relationship dax to be able to use location slicer. Here is the Dax but it gives an error of multiple values was supllied where a single value was expected. Could you help me on that please, thanks
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.