topic Re: DAX measure help ignore filter in DAX Commands and Tips

DAX measure help ignore filter

andreasalleslev — Mon, 22 Feb 2021 08:47:00 GMT

Hallo

Hope someone can help me. I havde this measure:

venuemanager =

var endags = CALCULATE(SUM('Digital produkt status'[Antal]), FILTER('Alle produkter', 'Alle produkter'[Type]="endags"))

var partout = CALCULATE(

SUM('Digital produkt status'[Antal]), ALL('Alle produkter'[Dag]), FILTER('Alle produkter', 'Alle produkter'[Type]="partout")

)

return endags + partout

and it return:

But i want this output: If type = "Partout" then ignore the day filter called "Dag" but it dont work

Best regards Andreas Alleslev

Re: DAX measure help ignore filter

rfigtree — Mon, 22 Feb 2021 09:02:50 GMT

does "dag" come from your calendar table, maybe you need to use filter(all(caledar, ... in your calculate.

other wise try FILTER(allexcept('Alle produkter','Alle produkter'[Type]), 'Alle produkter'[Type]="partout")

Re: DAX measure help ignore filter

andreasalleslev — Mon, 22 Feb 2021 09:02:21 GMT

Nope, is come from the product table. the product table have af "Type" and af "Dag" collum. and when the "type" is "Partout" then ignore the "Dag" collum.

Re: DAX measure help ignore filter

rfigtree — Mon, 22 Feb 2021 09:04:18 GMT

other wise try FILTER(allexcept('Alle produkter','Alle produkter'[Type]), 'Alle produkter'[Type]="partout")

Re: DAX measure help ignore filter

jameszhang0805 — Mon, 22 Feb 2021 09:13:25 GMT

Please try

VAR endags = CALCULATE ( SUM ( 'Digital produkt status'[Antal] ), FILTER ( 'Alle produkter', 'Alle produkter'[Type] = "endags" ) ) VAR partout = CALCULATE ( SUM ( 'Digital produkt status'[Antal] ), 'Alle produkter'[Type] = "partout" ) RETURN endags + partout

Re: DAX measure help ignore filter

andreasalleslev — Mon, 22 Feb 2021 09:15:14 GMT

Hmm, nope, is dosent work. it fails:

Re: DAX measure help ignore filter

andreasalleslev — Mon, 22 Feb 2021 09:33:15 GMT

thank for your answar. it gives the same result

Re: DAX measure help ignore filter

jameszhang0805 — Mon, 22 Feb 2021 09:53:21 GMT

Re: DAX measure help ignore filter

andreasalleslev — Mon, 22 Feb 2021 10:30:26 GMT

Hmm, no is the same result. But i have tried, and now i get the correct answar but the result is in the wrong row?? the result for Partout must be in the row partout