Power BI DAX function All that you can apply on a calculated measure to remove the impact of slicers or filters on the calculation.
Sometimes you want to see the sub category value and overall category value simultaneously and in those scenario, it can be helpful.
Power BI Tutorial Spreadhseet - https://docs.google.com/spreadsheets/...
All Tutorials Spreadsheet - https://datastudio.google.com/reporti...
Dataset Link - https://tinyurl.com/yd65vnf3