Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hallo
Hope someone can help me. I havde this measure:
But i want this output: If type = "Partout" then ignore the day filter called "Dag" but it dont work
Best regards Andreas Alleslev
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
thank for your answar. it gives the same result
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
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
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")
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.
other wise try FILTER(allexcept('Alle produkter','Alle produkter'[Type]), 'Alle produkter'[Type]="partout")
Hmm, nope, is dosent work. it fails:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |