Dax help

[sameergupta60]

Hi, 

in excel formula is 

=SUMIFS('Base File'!$O$2:$O$1760,'Base File'!$E$2:$E$1760,"="&Result!D6)

=SUMIFS('Base File'!$O$2:$O$1760,'Base File'!$E$2:$E$1760,"="&Result!D55,'Base File'!$M$2:$M$1760,">="&Result!$A$1,'Base File'!$M$2:$M$1760,"<="&Result!$B$1)

But in Dax sumifs is not working please help

we need help on two formula

[amitchandak]

@sameergupta60 , we have SUMX and with sum, we can use calculate and filter.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.