Skip to main content
cancel
Showing results for 
Search instead 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

Reply
ARomain
Helper I
Helper I

Count "No" cases when a Yes appears in the same column per unique ID

I am trying to figure out a measure to determine how many times a "No" answer appeared when a "Yes" answer appeared in the same column for the unique ID. I want to determine the values by the Name; San Francisco is not included in the values since there was not a "Yes" associated to that person.

 

image1.png

1 ACCEPTED SOLUTION
Barthel
Solution Sage
Solution Sage

Hey @ARomain,

Create a matrix in Power BI and place the locations in it. Then create the following measure that you can place in the matrix:

metric =
SUMX (
    KEEPFILTERS ( VALUES ( 'Table'[Name] ) ),
    VAR _name = 'Table'[Name]
    RETURN
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                'Table'[Risidence] = "Yes",
                ALLSELECTED ( 'Table' ),
                'Table'[Name] = _name
            ) > 0,
            CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Risidence] = "No" )
        )
)

 

View solution in original post

1 REPLY 1
Barthel
Solution Sage
Solution Sage

Hey @ARomain,

Create a matrix in Power BI and place the locations in it. Then create the following measure that you can place in the matrix:

metric =
SUMX (
    KEEPFILTERS ( VALUES ( 'Table'[Name] ) ),
    VAR _name = 'Table'[Name]
    RETURN
        IF (
            CALCULATE (
                COUNTROWS ( 'Table' ),
                'Table'[Risidence] = "Yes",
                ALLSELECTED ( 'Table' ),
                'Table'[Name] = _name
            ) > 0,
            CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Risidence] = "No" )
        )
)

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors