Forum Discussion

Kumshan450's avatar
Kumshan450
Helper 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
Helper III
8 years ago

using dax

Kumshan450's avatar
Kumshan450
Helper III
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))

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Kumshan450,

     

    Perfect! I see that you must be using Power BI then and not Power Pivot?

     

    Congrats and Kudos,

     

    Kris

  • Kumshan450's avatar
    Kumshan450
    Helper III
    8 years ago

    Yes i am using power BI