Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
30 | |
22 |