I am having two measures in my look. ‘Measure a’ is Count(*) and ‘Measure b’ is count(column) when creation_date <= Start_Date. The have drill fields for both filters and when I drill on measure A, I am getting correct results. But when I drill on Measure B, It is not just bringing the filtered data but also bringing other records that are present in ‘Measure a’ Drill.
Is there a way I can get only filtered values in Measure B drill down?