Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |