Forum Discussion
Single value in PBI
Hi! What is the measure to select a single value from a table, such as a current month value or any month value without comparing or accumulating them?
Hi DR2022
You can use SELECTEDVALUE to get a single value but I'm not sure that is really what you want based on your description, it's a bit vague.
Can you please provide soem detail about what you are trying to do and provide sample data and example of the desired result.
Regards
Phil
2 Replies
Hi DR2022
You can use SELECTEDVALUE to get a single value but I'm not sure that is really what you want based on your description, it's a bit vague.
Can you please provide soem detail about what you are trying to do and provide sample data and example of the desired result.
Regards
Phil
For example, a monthly sales table for a product. I wanted to create a measure to put on a card with only the most recent month's product sales. The most recent data value without sum or average
