Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello all
I have a problem, hope you guys can help
So I filtered by company and month to get an actual revenue.
Example:
If I want to filter [company 1] in February, the value will appear on the card. Furthermore, if I filter [company 1] with muti select in February and March, the card will only display the last value selected, which is March. So for the next. So whatever is selected, I just want to display the last actual value that was selected.
I have a problem because every time I do a multi select, then the value will be summed. But I only want to display the last selected value, not sum it up when i multi select the month
Please check the following file:
https://drive.google.com/file/d/1Jyq9DKiLb3JArLudGLzv1iyMgDeGRkU8/view?usp=sharing
Solved! Go to Solution.
Hi,
You may download my PBI file from here. I have selected Feb, Mar, Apr in the Month slicer
Hope this helps.
How to return the Sum for the last item selected in the slicer? My data does not use Calendar or include Months or Date Values.
Hi,
You may download my PBI file from here. I have selected Feb, Mar, Apr in the Month slicer
Hope this helps.
You are welcome.
@PowerVisualBI , make sure you also have month no(numeric) in your table.
then create a measure like
= var _max = maxx(allselected('Date') , 'Date'[Month])
return
calculate(sum(Table[Value]), filter('Date', 'Date'[Month] = _max))
Hello the greate user @amitchandak
I'm using the measure, not calculated column. So, calculate(sum(Table[value]), can't be used because it can only read calculated column in that condition, not with measure.
Maybe you can open my file first
Thank you
Hello mr @amitchandak
Looks like you failed to understand what I mean sir
This even creates an error. Maybe you can open my file first
Thank you
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |