Forum Discussion
Show maximum Yearmonth Value selected in the Dropdown.
- 6 months ago
Hi jishnubhattacha
As per my understanding of your requirement, could you please try the steps below?
1. disconnected table which you have already created .
Disconnected_YearMonth =
DISTINCT(FactTable[YearMonth])
2. Create a 1st measure .
Selected YearMonth =
VAR SelectedYM =
SELECTEDVALUE(Disconnected_YearMonth[YearMonth])
RETURN
IF(
ISBLANK(SelectedYM),
MAX(FactTable[YearMonth]),
SelectedYM
)
3. Third measure.
Total Sales (Selected YM) =
CALCULATE(
SUM(FactTable[Sales]),
FactTable[YearMonth] = [Selected YearMonth]
)
If this answers your questions, kindly accept it as a solution and give kudos.
Yes it is woking but with this option the selected item is also shown in the dropdown but other elements are not showing . like if my dropdown has 202601,202512,202511,202510 .. so on. The according to requirement 202601 will be selected by default in the dropdown. It is happening but other values got removed from the dropdown so it is not satisfying the whole requirement. If yuo need more explanation I can provide you with sample screenshots.
Hi jishnubhattacha,
I have attached the repro to your issue. Please check if it resolves your problem. If it doesn't, kindly send a screenshot of your issue.
Thank you.