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
