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.
Using the following code, I'm trying to get ALL to ignore a column filter. It should mean that all the colum values should be exactly the same. However, the values are different and ALL does not seem to be working. If I add ALL on the whole table, then it does work. However, this would not be acceptable as that would also ignore my row filters, which I do not want.
Any ideas as to how I can ignore just the column name? I don't have any age page level or visual level filters. Thanks.
MeasureName =
CALCULATE (
COUNTA ( tblJobs[ColumnName] ),
ALL ( tblJobs[ColumnName] )
)
Solved! Go to Solution.
Hi, i'm afraid that the file is very big and contains sensitive data. In the end, I pasted into Excel and worked out manually. It could be a bug, as the code is otherwise what it should be. This will probably not have a solution, so feel free to delete the thread. Thanks.
Hi @vpatel55
Thanks for reaching out to us.
When I test, the all() function works ok, could you please share a sample file for us to check? Thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi, i'm afraid that the file is very big and contains sensitive data. In the end, I pasted into Excel and worked out manually. It could be a bug, as the code is otherwise what it should be. This will probably not have a solution, so feel free to delete the thread. Thanks.
Thanks @Anonymous but same result i'm afraid, the column continues to filter.
Vpatel55,
Try to removefilters on postalcode, this is the last filter on your display ?
Thanks @Anonymous but same issue, in fact even if I remove PostcodeArea from the row axis, leaving just the column, it still filters by column (screenshot below). I'm not aware of any other filters at all. Its an odd one!
vpatel55,
last chance 🙂
your 0,1,2... what is this field ?
No problem @Anonymous , its a table of grouped numbers. The data type is decimal, but changing it to whole number doesn't change the result. My ultimate goal is produce a cumulative percentage. So that '1' is x% of the total, 2 is y% of the total, etc.
i,
Tyr this
MeasureName =
CALCULATE (
COUNTA ( tblJobs[ColumnName] ),
ALL ( tblJobs[ColumnName] ),removefilters(tblJobs[ColumnName] )
)
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |