Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
I have a measure "YTD Increase %", this measure itself doesn´t show any value when it's used alone, this measure is created specifically to show it with the years
What I need is the total average of the measure, for this calculation i have to use the value for each year, and in this new measure i most show it in the card visual.
Thanks in advance.
Harrinson A.
Solved! Go to Solution.
@Anonymous,
You may add an additional measure as follows.
Measure = AVERAGEX ( VALUES ( 'Table1'[Year] ), [YTD Increase %] )
@Anonymous,
You may add an additional measure as follows.
Measure = AVERAGEX ( VALUES ( 'Table1'[Year] ), [YTD Increase %] )
User | Count |
---|---|
91 | |
74 | |
71 | |
58 | |
55 |
User | Count |
---|---|
41 | |
39 | |
34 | |
32 | |
30 |