Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello! I have one very interesting challenge. If anyone has a solution for this, would be really amazing!
I would like to do the following:
Solved! Go to Solution.
Hi @PowerAnalytics,
At first, please create two measures to get the selected values from two slicers.
selectedCode1 = SELECTEDVALUE(Code1[Code1]) selectedCode2 = SELECTEDVALUE(Code2[Code2])
Then create a measure to get merged code using the formula below.
Filtered_mergedCode = IF ( FIRSTNONBLANK ( Data[Merged_Code], Data[Merged_Code] ) = Code1[selectedCode1] & Code1[selectedCode2], FIRSTNONBLANK ( Data[Merged_Code], Data[Merged_Code] ), BLANK () )
You will get expected result as follows.
You can download the attachment for check more details.
Best Regards,
Angelia
I'd try to do this backwards - have your data pull out the separate AB and 10 sections and then feed those columns into filters
Hi Thomson! Can you elaborate your suggestion?
bump
Hi @PowerAnalytics,
Based on my understanding, the col1, col2 and merged column from different tables. I assume col1 and col2 come from Table2, the Merged, country etc come form Table1. Please create a measure using the following fomula.
Merged = CALCULATE ( FIRSTNONBLANK ( Table1[Merged], Table1[Merged] ), FILTER ( Table1, IF ( COUNTROWS ( ALLSELECTED ( Table2[col1] ) ) = 1 && COUNTROWS ( ALLSELECTED ( Table2[col2] ) ), CONCATENATE ( SELECTEDVALUE ( Table2[col1] ), SELECTEDVALUE ( Table2[col2] ) ) = Table1[Merged], TRUE () ) ) )
Then add the measure in the table you want to display. And please share your .pbix file if you still have other issue.
Best Regards,
Angelia
Hello huizhn!
Thank you so much for your reply!
I tried to apply your formula but had no success.
Let me attach the PBIx as you suggested, and you are able to show me how this can work it would be amazing!
Hi @PowerAnalytics,
At first, please create two measures to get the selected values from two slicers.
selectedCode1 = SELECTEDVALUE(Code1[Code1]) selectedCode2 = SELECTEDVALUE(Code2[Code2])
Then create a measure to get merged code using the formula below.
Filtered_mergedCode = IF ( FIRSTNONBLANK ( Data[Merged_Code], Data[Merged_Code] ) = Code1[selectedCode1] & Code1[selectedCode2], FIRSTNONBLANK ( Data[Merged_Code], Data[Merged_Code] ), BLANK () )
You will get expected result as follows.
You can download the attachment for check more details.
Best Regards,
Angelia
Amazing Angelia, you are the best!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
124 | |
77 | |
75 | |
58 | |
49 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |