Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Guys,
I need to find average(count(column), Dax is not allowing to create measure with nested function. So I created a measure count(Coulmn) and on top of it tried to average, nothing works average function need column.
Kindly suggest me a solution for this its very urgent.
Thanx in advance.
Solved! Go to Solution.
Hi @saikarthick,
In order to achieve this you need to use an aggregator that is a value thart makes the calculations row by row and then returns the aggregator result.
All the aggregators finish in an X examples: MAXX, SUMX; AVERAGEX and the parameter are Table and function so you need to do:
AverageTotal = AVERAGEX ( Table; Count(Table[Column]))
This will make the count row by row based on context and then make an average of the values. It's calculated step-by-step.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @saikarthick,
In order to achieve this you need to use an aggregator that is a value thart makes the calculations row by row and then returns the aggregator result.
All the aggregators finish in an X examples: MAXX, SUMX; AVERAGEX and the parameter are Table and function so you need to do:
AverageTotal = AVERAGEX ( Table; Count(Table[Column]))
This will make the count row by row based on context and then make an average of the values. It's calculated step-by-step.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português