Forum Discussion
ALL function not working as expected for a DAX Formula
Super UserAnonymous , these seems correct. Are facing value issue or some error
DAX2 =NageGroup= CALCULATE(sum(DM_AgeGrouping[validRecordbit]),ALL(MainStarTable[OID]))
Means other then OID view in table, you should see filter on OID is removed. For the OID group by/view you will see total value without filter with selected value.
refer
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak Yes I know how this works. Problem is I'm missing some values in the OID columns which is not suppose to happen when OID filters are used. Again use the below link to download the sample file.
https://www.dropbox.com/s/s0xkou30i1g1keg/TestFile.pbix?dl=0