Connecting two columns in a fact table to the same dimension to filter measures in a field parameter

[GijsBI]

Hi, 

I have one fact table with two columns, ID_1 and ID_2, that I want to connect to the same dimensional table (and key). The values in column ID_1 and ID_2 are identical. I'm searching for a way to filter the measures in my field parameter (that are based upon this fact table) with a slicer. So, if a record contains a value for ID_1 or ID_2, I want to include this record in the calculation of my measure in my field parameter (if the value in ID_1 or ID_2 is the same as the value I selected within my slicer). 

I've tried creating two dimension tables, or connecting both ID columns to the dimensional table through an inactive relationship. Both options didn't work for my situation (or I did it wrong). 

What would be the best approach to do the above?

[v-lgarikapat · Accepted solution]

Hi @GijsBI ,

I’ve implemented the logic  with sample data  and uploaded a sample PBIX file for your review. Could you please take a look and let me know if it’s working as expected, or if any adjustments are needed?

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best Regards,

Lakshmi 

[v-lgarikapat]

Hi @GijsBI ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

Best Regards,

Lakshmi

[v-lgarikapat]

Hi @GijsBI ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[v-lgarikapat]

Hi @GijsBI ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[GijsBI]

Hi,

Thank you both for your quick response. I tried to add the links to the message but it did not work. I can share a direct link to my one drive account, but then you can see the company that I work for. It is desired to keep that private. 

[GijsBI]

Hi, 

Thank you both for your quick responses. I've added a link to the dimension, fact, and power BI example dashboard in this message. What I want is to filter the performance_processes 1-3 as displayed in the image below with dim_ID, which has two columns in the fact table. The measures for the performance processes are grouped within a field parameter. In my original dashboard, I want to be able to switch between different groups of measures. If you have any questions and need additional information, feel free to contact me. 

Files:

Power BI example 

Dim data 

Fact data 

Image:

[v-lgarikapat]

Hi @GijsBI ,

Thank you for sharing the Power BI (.pbix) file earlier. However, when I tried accessing it via the OneDrive link, I encountered an error stating that I might not have permission to view the item (please see the attached screenshot for reference).

Could you kindly re-share the file with the correct permissions so that it can be accessed without any restrictions?

For reference, please see the thread below where another user shared a file via a public link, allowing anyone to download it without requiring special access or permissions.

Thank you for your support.

Excel to Powerbi conversion formula help - Microsoft Fabric Community

Thanks in advance!

Best regards,
Lakshmi Narayana

Best regards,
Lakshmi Narayana

[GijsBI]

Hi Lakshmi, 

I tried to share the link but my company does not allow to share links outside the organization without specifying who I sent the file too. I thought I deleted the message with the above links, since it referred to my organization's sharepoint which you don't have access too. 

[GijsBI]

Hi both, 

Thank you for your responses. I've created a power BI example file and included the dim and fact data in Excel exports to this message. I've also added a screenshot, where we see the dim_id that I want to use to filter the performance processes 1-3 which are grouped in a field parameter. Please let me know if there's anything else you will need to help me with this problem :). Dim data Fact data Example dashboard 

[v-lgarikapat]

Hi @GijsBI ,

Thanks for reaching out to the Microsoft fabric community forum.

@Greg_Deckler 

Thanks for your prompt response

@GijsBI 

To better understand the issue and build the appropriate logic, it would be very helpful if you could share some sample data that fully represents the problem or question you're referring to.

Kindly ensure the data is

In a usable format (e.g., Excel or CSV), rather than a screenshot

Free of any sensitive or unrelated information

Looking forward to your response.

Best regards,
Lakshmi Narayana

[Greg_Deckler]

@GijsBI Sample data would really help. I am thinking that you likely need a Complex Selector and to keep your tables disconnected from one another entirely. The Complex Selector - Microsoft Fabric Community