Forum Discussion
Ignore a specific filter in a measure
Community ChampionThe logic looks correct to me. How do you know it is not working? I suggest create a matrix and put class 2 on rows. Then put the measure you wrote in the values for the matrix. From what I can see, it should return the same result all the way down the matrix = working as design.
Hi Matt,
Sorry about the slow response - I have been working on another project.
I tried your suggestion of putting it on a matrix, and I do not get the expected result
The first measure Total Visits is the same as in my initial posts
The Second Number of Visits is simply Number of Visists = countrows(visits)
They both return the same values - I can't seem to attach an image.
I'd rather achieve this with a measure rather than a second unrelated table as there are still things I do need to filter.