cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## DAX measure help ignore filter

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

8 REPLIES 8
Resolver IV

``````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``````

Helper I

thank for your answar. it gives the same result

Resolver IV
``````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``````
Helper I

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

Resolver III

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

Helper I

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.

Resolver III

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

Helper I

Hmm, nope, is dosent work. it fails:

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors