DAX measure help ignore filter

[andreasalleslev]

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

[rfigtree]

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") 

[andreasalleslev]

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. 

[rfigtree]

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

[andreasalleslev]

Hmm, nope, is dosent work. it fails:

[jameszhang0805]

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

[andreasalleslev]

thank for your answar. it gives the same result

[jameszhang0805]

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'[Dag] = "partout"
)

RETURN endags + partout

[andreasalleslev]

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