Forum Discussion
Solved
Combining 2 Dax formulas
Hello, I just start recently to learn by myself Power BI. I want to combine Countrows with Contains but it is not functioning. Could you please tell me what i do wrong here? Available Veh ...
Hello,
First, your IN function is not correct, the right synatx is: IN {"chokolate","Caramel","Vanilla"}For your dax function, this one should work
CALCULATE(
COUNTROWS(Tabel1),
Tabel1[Type] IN {"chocolate", "caramel", "vanilla"},
FILTER(Tabel2, Tabel2[Available Stock] = "true")
)Do not hesitate to ask if it is not working or share a sample of your dataset
Cookistador
Super User
Super UserHello,
First, your IN function is not correct, the right synatx is: IN {"chokolate","Caramel","Vanilla"}
For your dax function, this one should work
CALCULATE(
COUNTROWS(Tabel1),
Tabel1[Type] IN {"chocolate", "caramel", "vanilla"},
FILTER(Tabel2, Tabel2[Available Stock] = "true")
)
Do not hesitate to ask if it is not working or share a sample of your dataset