The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I've got a table looking like the following:
Month R19/20 R20/21 Growth
Jul 10 20 100%
Aug 20 25 25%
Sep 5 10 100%
Oct 10 10 0%
Nov 5
Dec 7
Jan 10
Feb 2
Mar 6
Apr 8
May 5
Jun 7
Jul 9
Total 104 65 -37,5%
Can I somehow make the total of the growth column only show the total of the visible values (I guess: (100+25+100+0)/4)? But without only showing the visible values. (I still want to show Nov-Jul even though there is no data in the growth column)?
All of the columns are measures.
Solved! Go to Solution.
Hi @Anonymous
Create another measure using the one you have:
Growth TOT=
AVERAGEX(DatesT[Month], [Growth] )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Anonymous
Create another measure using the one you have:
Growth TOT=
AVERAGEX(DatesT[Month], [Growth] )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |