Filter Data and show only one date per record

[Anonymous]

Hello Community, 

I am currently trying to find a way to permanent filter the Sequence E2E and Sub-Group Sequence E2E below from multiple rows with the same vendor name/ number. I want to only show the lowest number of Sequence E2E and Sub-Group Sequence E2Eper vendor name/vendor Number. 

For Example: with Vendor Name Aladdin Temp Rite i want to only show Sequence E2E and Sub Group Sequence E2E to 1 and 1. 

Thank you so much for helping me, 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could create a measure as below to get the min value of each vendor name/vendor Number.

Measure = CALCULATE(MIN('Table'[value1]),ALLEXCEPT('Table','Table'[ID]))

Measure 2 = CALCULATE(MIN('Table'[value2]),ALLEXCEPT('Table','Table'[ID]))

 

Then create another measure to compare the record with these min value.

Measure 3 = IF(SELECTEDVALUE('Table'[value1])=[Measure]&&SELECTEDVALUE('Table'[value2])=[Measure 2],1,0)

At last, add the second measure to filter.

Best Regards,

Jay

[amitchandak]

@Anonymous , refer

https://community.powerbi.com/t5/Desktop/M-Power-Query-Removing-entire-rows-based-on-condition/td-p/367563

https://social.technet.microsoft.com/Forums/en-US/acb06cd7-f0c7-44f9-8b7e-5e74ffd32780/remove-rows-which-consists-of-specific-value-in-a-specific-column?forum=powerquery

https://stackoverflow.com/questions/40176357/conditionally-deleting-rows-in-power-bi

[Greg_Deckler]

@Anonymous - Are you trying to do this in Power Query or create a new table using DAX or ?

[Anonymous]

Hello, I am trying rebuilt the table using DAX