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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ARomain
Helper I
Helper I

Count ID by Region when data is duplicated

I am trying to create a new measure that counts data, but I have an issue with the way data is given to me.

 

One row will show when an organ was accepted and then transplanted. In the example below, Chicago accepted a right kidney, and it did end up going to a recipient. However, the left kidney was accepted in an offer not in the data, and it ended up going to New York. However, sometimes, the data will repeat (this data is given to me).

 

ARomain_0-1710435299620.png

 

I want to disregard the middle row. Chicago did do the right kidney but not the left, as indicated by row 3. However, New York did the Left Kidney, but was not offered it fomally. Is there a way to create a measure that disregards the second row since row 3 has the correct data for Chicago and since row 1 is unique with New York?

 

By ID, I want the measure to count as....

New York=1

Chicago=1

 

1 REPLY 1
v-tianyich-msft
Community Support
Community Support

Hi @ARomain ,

 

What is the basis of this count, why blank is also regarded as a count, to be able to more detailed elaboration of your needs well.

 

Best regards,
Community Support Team_ Scott Chang

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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