topic Re: All Function not working in DAX Commands and Tips

All Function not working

Pranali_R — Tue, 07 Nov 2023 11:03:39 GMT

CALCULATE(

SUM(Table[marks]),

FILTER(

Table,

Table[grades] = "Average"

ALL('Calendar'[year])

Why is my ALL('Calendar'[year]) not working, I want it to not be affected by this Calendar

year slicer

Dangar332 v-cherch-msft

Re: All Function not working

Dangar332 — Tue, 07 Nov 2023 11:05:40 GMT

Hi, Pranali_R

you use AlLL() as a calculate modifier which remove filter context not ignore outer filter

for ignoring outer filter you must usr ALL() as a table function.
for more dive in ALL() function refer HERE

sumx( filter( all('table'), --- use as a table function so ignore outer filters table[grades]="Average" ), Table[marks] ) or CALCULATE( SUM(Table[marks]), FILTER( all(Table), Table[grades] = "Average" ) )

Re: All Function not working

mlsx4 — Tue, 07 Nov 2023 11:11:07 GMT

Hi Pranali_R

You can do this:

Measure = CALCULATE( SUM(Table[marks]),ALL('Calendar'[year]), Table[grades]="Average")

Re: All Function not working

Dangar332 — Tue, 07 Nov 2023 11:30:16 GMT

hi, Pranali_R

you can use edit interaction

please visit HERE

Re: All Function not working

Pranali_R — Tue, 07 Nov 2023 12:44:37 GMT

Hi Dangar332 ,

I understand this issue, But the thing is, my filter table and calendar table is different, so how should i accomodate the filter from 2 different tables and use ALL as a table function

Re: All Function not working

mlsx4 — Wed, 08 Nov 2023 09:13:52 GMT

Pranali_R have you tried this?

If both tables are related, it should work

Re: All Function not working

Dangar332 — Wed, 08 Nov 2023 09:40:46 GMT

Hi, Pranali_R

try below

CALCULATE( SUM(Table[marks]), FILTER( all('Calendar'), X -- use column name which participate in relationship b/w tables(table and calender) ), 'table'[grades]="Average" )