Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |