Forum Discussion

BhavyaM's avatar
BhavyaM
Helper V
4 years ago

How to eliminate data using DAX

I have data as below,     is there any way to elimate the first two rows data and Keep only Unique values in the visual. please help.   Thanks in advance  
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi BhavyaM ,

 

I seem to be a bit confused about your description. As shown in the screenshot below, according to your requirement, you need to group Product by category and then delete the rows whose Value values add up to 0. If the same Product has more than one column with the same value, how do I do it and what are the conditions based on?


Please solve my confusion, so that I can do further testing. Looking forward to your feedback.


Best Regards,
Henry


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

BhavyaM's avatar
BhavyaM
Helper V
4 years ago

Yes, If the same Product has more than one column with the same value we have to show only that non zero values. There is no other conditions only based on Category and Product we have to show the values which are not equal to 0

 

  • BhavyaM's avatar
    BhavyaM
    Helper V
    4 years ago

    Can anyone having solution. Please help on this.