Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ALL function not working as expected for a DAX Formula

 
Hi, 

I'm working on a PowerBI report  and one of the DAX is not working as expected. I use various filters in the page and at a particular scenario the ALL function is not working as expected.

 

For example I use below filters

1. MainStarTable[OID]

2. MainStarTable[FID]

3. MainStarTable[LengtOFstay]

4. MainStarTable[DateRange]

 

When using only FID and OID filters all the below DAX is returing the expected results. But when I use all the filters combined DAX3 and DAX2 is not working as expected

 

DAX1  =ageGroup= CALCULATE(sum(DM_AgeGrouping[validRecordbit]))

DAX2  =NageGroup= CALCULATE(sum(DM_AgeGrouping[validRecordbit]),ALL(MainStarTable[OID]))

DAX3  =OageGroup=CALCULATE(sum(DM_AgeGrouping[validRecordbit]),ALL(MainStarTable[FID],MainStarTable[OID])

 

Problem is with DAX3 and DAX2. For some reason DAX3/DAX2 is not utilizing the function ALL(MainStarTable[FID],MainStarTable[OID])

 

If anyone have any suggestion, please let me know. Thanks

Need Help
Need Help DAX

2 Replies