Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
MSAYED26
Helper II
Helper II

count with filter

MSAYED26_0-1702992721282.png

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

I used this measure 

Measure 2 = IF([Measure]=1,"Solo","Multi")
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
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.

View solution in original post

2 REPLIES 2
MSAYED26
Helper II
Helper II

MSAYED26_0-1703145300498.png

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]
    )
v-shex-msft
Community Support
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.

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

Top Kudoed Authors