Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Code that pulls out values when they differentiate between columns

Is there a way to to pull out rows that have a duplicate value in one column but different value in another column     So when I load this dataset into PowerBI, I want to to pull out IDs 1 a...
Need Help
Tips and Tricks
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Create a measure like this and apply it to visual level filter.

Measure 4 = CALCULATE(DISTINCTCOUNT('Table (2)'[Program]),ALLEXCEPT('Table (2)','Table (2)'[ID]))

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.