Forum Discussion
Solved
Formula Help
Hi there ; İ need a your kind supports for a formula i would like to explain with below simple table ; i have a column with many vendor names in a table as below , on this table ; Ve...
erhan_79 Please create a table with as per below
Table = VAR _table = TOPN(3,SUMMARIZECOLUMNS(Test[Vendor Name],"CountOfVendor",COUNT(Test[Vendor Name])),[CountOfVendor],DESC) VAR _top3 = SELECTCOLUMNS(_table,"Vendor Name",Test[Vendor Name],"Top number of vendor",RANKX(_table,[CountOfVendor])) RETURN _top3erhan_79 Please filter out the blank cells before counting. Replace
COUNT(Test[Vendor Name]) with below formula
CALCULATE(COUNT(Test[Vendor Name]),FILTER(Test,Test[Vendor Name]<>BLANK()))
