Forum Discussion

Kumshan450's avatar
Kumshan450
Icon for Helper III rankHelper III
8 years ago
Solved

Create new table by filtering column value

Hi,    I have created a calculated column which will count rows that are duplicate.   Count = CALCULATE(countrows(Receiptdump),ALLEXCEPT(Receiptdump,Receiptdump[RECEIPT_NO]))   Receipt no ...
Need Help
  • Kumshan450's avatar
    Kumshan450
    8 years ago

    Hi I Finally got the answer, 

     

    I created the new table by applying the formula using calculate table function. 

     

    Distinctreceiptdump = CALCULATETABLE(Receiptdump,filter(Receiptdump,Receiptdump[Count]=1))

Kumshan450's avatar
Kumshan450
Icon for Helper III rankHelper III
8 years ago

Yes i will check 

 

Is there any I can create a new table from the existing table in power pivot table data model with count value =1. This will definitely give me an accurate distinct table. 

Kumshan450's avatar
Kumshan450
Icon for Helper III rankHelper III
8 years ago

using dax