Hello there! Here are the details about the problem I have:
I want to count the number of values in one column, without another column's duplicates affecting it.
Example: I have a table with multiple columns. The columns that matter most are "No." (detail number) and "Family". I want to count the number of values in the "Family" column without "No. Values" affecting them. Whenever the "No." column has a value count of more than 1 (in this example - 1282370) - it should count as 1.
The result would be: the SDB count for 1282370 - 1. Duplicates don't count.
there are other "detail numbers" that can have the same family. Hence, if the count of one detail for the same family is >1 - it should count as 1.
what would be the DAX expression to get these values?
Helpful resources
Power BI T-Shirt Design Challenge 2023
Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.
March 2023 Events
Find out more about the online and in person events happening in March!
