Forum Discussion
Solved
Use DAX Measure as Categories
Consider the following table: Name Field Value A ABC -10 A DEF 15 B ABC -20 B DEF 25 C ABC 15 D ABC 20 D DEF 25 E ABC -1 E DEF 2 I am tryi...
apollo89 , Check new category column
Hi,
These calculated column formulas work
Total for Name = =CALCULATE(SUM(Data[Value]),FILTER(data,Data[Name]=EARLIER(Data[Name])))Total for all names = SUM(Data[Value])Threshold = 0.05*[Total for all names]Category = if([Total for name]>[Threshold],Data[Name],"Others")Hope this helps.
Thank you amitchandak and Ashish_Mathur ! I understand the EARLIER function was vital to this. Thank you both for your efforts!
You are welcome.