Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two fact tables A & B. From A I am pulling data on cost, from B budgets. For both I created calculated column which is a combination of three columns. I also created another table C joining these with one to many relationship. The goal is to filter table A and B, using table C. If value exists in a table A & B i want to call this filter "Including", if not "Excluding".
Table A:
cost center | account | entity | cost ($) | calculated_col |
A | 1 | X | 10 | A1X |
B | 2 | Y | 20 | B2Y |
C | 3 | Z | 30 | C3Z |
Table B:
cost center | account | entity | cost ($) | calculated_col |
A | 1 | X | 10 | A1X |
B | 2 | Y | 20 | B2Y |
C | 3 | Z | 30 | C3Z |
Table C:
A1X |
CVY |
C3Z |
My current solution is I set up filter to be calculated column from table A, set bidirectional filtering to table C and then from C to A single filtering. But the filter works only if i select and deselect and select one more time.
Solved! Go to Solution.
Hi @glizzzd ,
Based on your description, I created the following dax expression and applied it to this visual object
Measure =
IF(
SELECTEDVALUE('Table A'[calculated_col]) IN VALUES('Table C'[Filter]),
"Including",
"Excluding"
)
When we set the filter condition to "Including", the visual object will keep all the data with "Including" returned by the measue condition, and these filtered data can still be used by other filters afterward. filtered data can still be used by other filters later. In the end, the visual object will only keep the data that matches all the filters.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @glizzzd ,
Based on your description, I created the following dax expression and applied it to this visual object
Measure =
IF(
SELECTEDVALUE('Table A'[calculated_col]) IN VALUES('Table C'[Filter]),
"Including",
"Excluding"
)
When we set the filter condition to "Including", the visual object will keep all the data with "Including" returned by the measue condition, and these filtered data can still be used by other filters afterward. filtered data can still be used by other filters later. In the end, the visual object will only keep the data that matches all the filters.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Filter on the visual:
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |