Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
It appears that instead of summing the totality of my data set, my KPI is defaulting to the HIGHEST TOTAL WITHIN MY DATA SET and displaying that. Is it possible for KPI's to default to the total amount of all the data and still have dynamic abilities? It works fine individually, but I'd like to have a Total measure similar to the guage in the top picture?
Solved! Go to Solution.
Hi @bw70316,
Please create a measure similar to below and add it to KPI.
Total = CALCULATE ( SUM ( table[Value] ), ALLSELECTED ( table ) )
Best regards,
Yuliana Gu
Hi @bw70316,
Please create a measure similar to below and add it to KPI.
Total = CALCULATE ( SUM ( table[Value] ), ALLSELECTED ( table ) )
Best regards,
Yuliana Gu
Hi, Thank you! It works but I've just lose the trend axis in that way... any idea?
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |