I want this filter to be part of the my previous ytd calculation, however when i use this in visual or page level filters, it works fine and gives only true records.
if i use it inside dax like, it does not filter the true values. The main reason behind putting this in dax is i need to calculate Variance %, if i put visual level filters for %variance, the results are wrong, I need the filter in dax so that
the % calculation is accurate. Can you please look into it. PYTD, YTD and Variance all are measures.
Please find the pbix attached and the desired output is shown, I have used visual level filters and I am geeting desired % variance, but I want that the calc column(Sample1_IsSamePeriodLY) inside DAX? is there a way?