Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |