Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I wonder if it's possible to set two filter on a page or a table for two different colums that are combined with a logical AND.
example table:
Material | Actual | Margin |
ABC | 150 | 0 |
BCD | 0 | 120 |
CDE | 0 | 0 |
I only want to get rid of material CDE, but when I set two filter "Actual is not 0" and "Margin is not 0" all record sets dissappear.
It seem the logical AND is only available within one column. Is there a way to get to the filtered table?
Thanks
Solved! Go to Solution.
You can include this measure as a visual level filter without including it as a column.
Navigate to the 'Add a filter to a visual' section in the below link to see how this can be done:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
You can include this measure as a visual level filter without including it as a column.
Navigate to the 'Add a filter to a visual' section in the below link to see how this can be done:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
You could create a new measure which sums actual and margin, then use this as the filter:
Combined = Table[Actual] + Table[Margin]
Combined = Table[Actual] + Table[Margin]
doesn't work for me, as I can not use a column name without aggregation directly in a measure.
This one will work:
Combined = SUM(Table[Actual]) + SUM(Table[Margin])
but I' have to add it to my table. I donn't want the user to see this column.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |