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.
i am trying to filter my sales table in query advanced filtering. i want to only see accounts >=1 AND <=10, OR 12.
when i do this, i can load the filtered file and see the selected accounts fine. however when i create a matrix, with any field, it shows blank reaults as if the table is empty?
if i revert back to a full file; all works fine?
Solved! Go to Solution.
I’m not quite sure how you apply the filter, but you can try to use CALCULATETABLE Function (DAX) to get the expected result.
Assuming we have a simple table like below.
We can use following DAX formula to create a new calculated table to filter the accounts.
Table2 = CALCULATETABLE ( Table1, Table1[Accounts] >= 1 && Table1[Accounts] <= 10 || Table1[Accounts] = 12 )
Then drag the filtered columns in the new created Table2 into Matrix fields.
Best Regards,
Herbert
Thanks, I will for sure use CALCULATETABLE in the future now!
I was using the Number filter from within Query, you drop down a field and one option is number filter, then I choose between, then choose 'advanced' to put in my filter conditions.
I am not sure what I did different, but it works AND shows results in my table/matrix.
Thanks again!
I’m not quite sure how you apply the filter, but you can try to use CALCULATETABLE Function (DAX) to get the expected result.
Assuming we have a simple table like below.
We can use following DAX formula to create a new calculated table to filter the accounts.
Table2 = CALCULATETABLE ( Table1, Table1[Accounts] >= 1 && Table1[Accounts] <= 10 || Table1[Accounts] = 12 )
Then drag the filtered columns in the new created Table2 into Matrix fields.
Best Regards,
Herbert
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |