Forum Discussion

o59393's avatar
o59393
Post Prodigy
3 years ago
Solved

Calculated column for duplicate values

Hi all   I need a calculated column that sums the distinct count values in the 'Pack' column for the concat of the columns 'Location' and 'Manufacturing line'.   To give an example here is the fo...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This calculated column formula works

    Column = CALCULATE(DISTINCTCOUNT(Data[Pack]),FILTER(Data,Data[Location]=EARLIER(Data[Location])&&Data[Manufacturing line]=EARLIER(Data[Manufacturing line])))

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

This calculated column formula works

Column = CALCULATE(DISTINCTCOUNT(Data[Pack]),FILTER(Data,Data[Location]=EARLIER(Data[Location])&&Data[Manufacturing line]=EARLIER(Data[Manufacturing line])))

Hope this helps.

 

o59393's avatar
o59393
Post Prodigy
3 years ago

Amazing Ashish_Mathur 

 

You are the best.

 

Thanks a mill.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    You are welcome.  Thank you for your kind words.