Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All,
Looking for suggestion to solve a problem
triptime (column C ) is a measure column
now i want to find the total average - of trip time which is 322.84 in this case and want to calculate how each driver is doing against average.
I tried using CALCULATE(AVERAGE(measure)) and few other methods but did not work
below is the example to calculate Average %
any help is appreciated.
Regards,
K
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Thank you so much - this really solved my problem. Missing REMOVEFILTERS() - i never thought about it
But i have another question, this will disable all the filters - how can i exclude few specific - like i want to use few - i tried using KEEPFILTERS() but i guess its not working as expected.
to exclude something specific you need to use ALLEXCEPT functions
or additionally write VALUES:
Hi,
Share the download link of the PBI file.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |