cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## count with filter

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

I used this measure

Measure 2 = IF([Measure]=1,"Solo","Multi")
1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Helper II

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]
)
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.