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.
I have tried searching the forum and can't find anything relevant and am wondering if anyone can help with my simple question - thanks in advance
I have 2 columns e.g.
Total $ # People
$100,000 50
$30,000 20
I want to have a ReportCard simply showing the average amount i.e. SUM($)/SUM(# people) = $130k / 70 = $1,857
How do I do that in the reporting interface?
Thanks
Solved! Go to Solution.
nevermind - i figured it out...
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |