User Profile
Danielle_1
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Re: Matching a result in a third column based on the selections in two other columns.
Hi tamerj1 , I have my visuals set up as below. I have disabled the interaction between these 2 slicers so a branch number, and postcode can be selected individually. I placed 2 tables below to display the supporting CSC based on the selected branch/postal sector. I have tried your measure, and it didn't work. Appreciate the response.1.3KViews0likes4CommentsRe: Matching a result in a third column based on the selections in two other columns.
Hi tamerj1 Thanks for the response, unfortunately that didn't work. I added the measure to a card, selected CF83 3 for the postcode sector in the first slicer, and then selected branch 2810 in the second slicer (based on the data in the snapshot above), and the result was "Yes" when it should have been No, as "Cardiff" and "Bolton" don't match.1.4KViews0likes6CommentsMatching a result in a third column based on the selections in two other columns.
Hi, I'm trying to create a measure where I need to generate a yes or no message to display in a card, based on the selection in 2 columns/slicers, and whether the results in the third column/rows (CSC) match each other or not (based on these 2 seperate selections) The first column (Postcode Sector) has duplicate values and the second column (Branch Number) has many blanks. I'm new to Power BI, so any help is appreciated. Thanks in advance.Solved1.4KViews0likes8Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.