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
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
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 |
---|---|
113 | |
91 | |
86 | |
76 | |
66 |
User | Count |
---|---|
149 | |
117 | |
111 | |
106 | |
95 |