Combining 2 Dax formulas

SophieM

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 = COUNTROWS(FILTER(Tabel1, Tabel1[Type] in {chokolate, caramel, vanilla})); Contains(Tabel2(Available Stock; "true"))

Cookistador

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

SophieM

thank you very much

Cookistador

If your issue is solved, do not hesistate to mark my post as a solution!

If not, do not hesistate to ask me for more help 🙂

Cookistador

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

Helpful resources