topic Re: count with filter in DAX Commands and Tips

count with filter

MSAYED26 — Tue, 19 Dec 2023 13:35:03 GMT

I want to count from measure "Multi", "Solo"

I used this measure

Measure 2 = IF([Measure]=1,"Solo","Multi")

Re: count with filter

Anonymous — Wed, 20 Dec 2023 06:10:35 GMT

HI MSAYED26,

You can try to use the following measure to calculate the result based on current measure value group:

formula = VAR summary = SUMMARIZE ( ALLSELECTED ( Table1 ), [Materials], "M1", [Measure1], "M2", [Measure2] ) RETURN COUNTX ( FILTER ( summary, [M2] IN VALUES ( NewTable[Materials] ) ), [Materials] )

Regards,

Xiaoxin Sheng

Re: count with filter

MSAYED26 — Thu, 21 Dec 2023 07:57:46 GMT

I used the measure but no data

Measure 3 = VAR summary =

SUMMARIZE (

ALLSELECTED ( Incoming ),

[Material],

"M1", DISTINCTCOUNT(Incoming[Suppliers]),

"M2", IF([Measure]=1,"Solo","Multi")

)

RETURN

COUNTX (

FILTER ( summary, [M2] IN VALUES ( Incoming[Material] ) ),

[Material]

)