Forum Discussion
Solved
Distinct count for specific values
Hello I am new to Power BI and am looking to do a specific calculation. I have day to day data on the performance of several channels (there are about 100). Some days these channels perform very ...
Elache ,
Try like
calculate(Sumx(Summarize( Table, Table[Channel], Table[Cost]), [cost]) , TOPN(1, filter(allselected('Table'[Channel]), Table[Cost]>0) , Sum(Table[Cost]),desc), values(Table[Channel]))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
It did work perfectly! Thank you so much amitchandak ; i was lost since so long!