Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All
As shown in 1st Screenshot, I have selected 2018 and there is value for the selected year and same for 2019 & 2020 and for 2021 there is Blank Value. But the problem is when I am selecting All years it's giving "Blank" instead of giving sum for all years.
Thanks in advance guys !
Hi @jay_patel ,
Are you using SELECTEDVALUE()? If it is, select all will not work. You can check my demo from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @jay_patel
Please share your sample pbix file's link here, then I can try to have a look into it to come up with a suitable solution.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |