Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello everyone,
I have a measure that is calculating the "% Expend" for each of the rows in the table. However, when no row is selected, the measure calculates the overall "% Expend".
I would like this measure to show no calculation at all for the overall and just show the value when any of the rows are selected.
Thank you!
Solved! Go to Solution.
@Anonymous
Try something along the lines of:
selected row = IF(ISFILTERED(Table [field]), [% Expend])
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
Try something along the lines of:
selected row = IF(ISFILTERED(Table [field]), [% Expend])
Proud to be a Super User!
Paul on Linkedin.
it worked perfect.
Thanks a lot!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
120 | |
74 | |
72 | |
58 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |