I have a chart visualization that I need to add a column to. I have a column that has part numbers and I need to add a new column that assigns a % value to each distinct part number.
Do you want to bring how much (%) the number of pieces represents? Imagining that's it, try the expression with the total qualifier adapted to your model.
Count(distinct [field-parts])
/
Count (distinct total [field-parts])
Att, Matheus
Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!