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.
Hopefully someone can help me with the following problem.
I did create a visualization (just a table) that also contains following columns
SalesOffices with Sales office country
IObOL new (incl K Group) with Country (Final ship to)
Now I would like to integrate a formula/ filter or whatsoever that filters all lines with identical countries for Sales office country and Country (Final ship to).
As an example, please see the screenshot. My idea is that only the highlighted ones should remain.
Is this possible? And how? I do not have any idea…
Solved! Go to Solution.
Use following measure:
Measure= IF(SELECTEDVALUE('Table'[Column1])=SELECTEDVALUE('Table'[Column2]),1,0)
And use this measure into visual level filter and set this measure's value 0.
Use following measure:
Measure= IF(SELECTEDVALUE('Table'[Column1])=SELECTEDVALUE('Table'[Column2]),1,0)
And use this measure into visual level filter and set this measure's value 0.
Thank you, it worked perfectly.
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 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |