Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
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" )
)
)
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" )
)
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |