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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors