Forum Discussion
Creating unique value column based on two filters
Hello all! I have what I believe to be a straight forward problem but really struggling with the solution. I want to get the number of active (open) franchises in a region and create a new co...
Hi Anonymous
1. Place Table1[Region] in the rows of a table visual
2. CREATE this measure and place it in the visual
Measure = CALCULATE( DISTINCTCOUNT( Table1[Franchise #] ), Table1[Open] = "Yes")
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi Anonymous
1. Place Table1[Region] in the rows of a table visual
2. CREATE this measure and place it in the visual
Measure = CALCULATE( DISTINCTCOUNT( Table1[Franchise #] ), Table1[Open] = "Yes")
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Perfect. I knew it was simple, just needed som help.
Thank you!