REMOVE FILTER (Not returning all categories but rather less categories at next level)
Hi, I have a tricky situtation wherien I need to report both zip and state related information with data in a narrow format in one table. If i am using remove filter, I am getting returned the numbers corresponding to only 2 categories male and female (while for some reason its hiding the unknown counts). Test Data - test_data.xlsx Pbix File - test_exclude_filter_dax.pbix I am relatively new to the powerbi dax, request the experts to help help me on this. Regards,Having issue with one of the DAX calculation that I am writing, Dax is somehow filtering categories
Hi @members PowerBI Everyone, I am new to Powerbi and having some issue that I am trying to fix. Any help will be appreciated I have data columns such as strata_val, products,units, statelookup. wherein both state and zip level information are existing under the strata_val. I am writing a dax to removefilter on slicer selection (populating using strata_val(zip)) and using the statelook to create a stratified state level information. Challenge is that, its filtering the categories on basis on whatever is exisiting only in the zip level. So, if state level has 4 categories, and zip has only 3 categories information, then using dax the chart is returning only 3 category specific information, while i want it to return all the 4 categories Measure = CALCULATE(sum('Table'[Units]),REMOVEFILTERS('Table'[strata_val]),'Table'[strata_val] = SELECTEDVALUE('Table'[LookupState])) Snapshot Sample data country strata_val Product Units LookupState US WA A 1 US WA B 2 US WA C 3 US WA D 4 US 980 A 1 WA US 980 B 2 WA US 980 C 3 WA US 980 D 3 WA US 981 D 1 WA
