Forum Discussion
ALL() function not working as expected
So you said it changes when you apply your date slices, is the date field in your slicer from your main table or from a separate calendar/date table. If it's from a separate table try putting the all statement around that field/table instead
Hello,
I have a matrix visual with 8 to 9 columns and have one page level filter(Values:1,2,4--Applied filter not in 4) and one report level filter(Applied filter sales not in US) applied to the report. Now, when ther user filter(Yes/No filter name) out of 8 to 9 columns, 3 columns values should not be effected in the matrix but when the user selects other filters, values should change. I have all the columns and filters coming from the same table.
Can anyone help me out in getting this?
I have tried using this
Calculate(DISTINCTCOUNT(column),All(Yes/No)) is not giving me the correct result.
Hi,
Assuming the title of the Yes/No column is response and the Table name is Data, try this
=Calculate(DISTINCTCOUNT(column),All(Data[Response]))
Hello,
Thank you for your response, I just mentioned Yes/No for understanding. I did use the column name it is not working as expected when I have one more filter from the same table. Could you please help me out?
Hi,
Share some data, explain the problem and show the expected result.
