Forum Discussion
SQL Server DB - How to recreate a relationship if it is hard coded in the original software
I have 3 tables like this:
Clients
Code | Name | Class 1 | Class 2 | Class 3
Classes
IDClass | ClassName
ClassValues
IDClassValue | ClassValue | IDClass
In the classes table I have 36 records prestablished for 6 different objects (client, products, agents, etc) which are ordered in groups of 6 (i.e. IDClasss 1-6 are for Agents, 7-12 are for Clients, etc) and in the Clients.Class1 field I have The IDClassValue which tells me that it is hard coded int he sw that when you refer to a Clients Class1 you have to look for the IDClass = 7 in the ClassValues table in order to find the records with the different Class1 options for a Client. How can I specify this in a report so I can show the client name and the Class1 name for that client?
1 Reply
Elemental , Active/inactive relationship; Create multiple measures using userelationhip and use field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
