I have written Dax to get the values of earlier “Sub-Category” value on the basis of “Sort-Id”, wherein I am getting right result on “Sub-Category” level but the “Category” level total is not showing correct result.
Attaching PBIX file along with feeding excel as well.
Previous.pbix (48.3 KB)
Book2.xlsx (200.2 KB)