Forum Discussion
Get Data from different Entity using Id
Hello,
I have created an entity "GetPlantUseCase" where all the data is merged based on the Id's. Now I want to show in my dashboard not the Id's but the corresponding names which are in the other entities.
Is there a way to display the corresponding names of the data in the other entities based on the Id's in "GetPlantUseCase"?
Thanks in advance!
Hi RebThu ,
According to your description, here are my steps you can follow as a solution.
(1)My test model is the same as yours.
(2) We can create three alculated columns.
Plant Name = RELATED(GetPlants[PlantName])Solution Name = RELATED('GetSolution'[SolutionName])UseCase Name = RELATED(GetUseCase[UseCaseName])Alternatively, you can use LOOKUPVALUE() functions.
Column = LOOKUPVALUE('GetPlants'[PlantName],'GetPlants'[id],'GetPlanUseCase'[id])(3) Then the result is as follows.
Please refer to the following document for more information.
RELATED function (DAX) - DAX | Microsoft Learn
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi RebThu ,
According to your description, here are my steps you can follow as a solution.
(1)My test model is the same as yours.
(2) We can create three alculated columns.
Plant Name = RELATED(GetPlants[PlantName])Solution Name = RELATED('GetSolution'[SolutionName])UseCase Name = RELATED(GetUseCase[UseCaseName])Alternatively, you can use LOOKUPVALUE() functions.
Column = LOOKUPVALUE('GetPlants'[PlantName],'GetPlants'[id],'GetPlanUseCase'[id])(3) Then the result is as follows.
Please refer to the following document for more information.
RELATED function (DAX) - DAX | Microsoft Learn
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.