Forum Discussion
Interactive Measure Dashboard
Hi Deveiopers,
Is there anyway or is it possible to have a interactive measure?
Dashboard Scenario
Filter :
Date 1
Date 2
Measure scenario
If I choose Date 1 Filter the visuals computation will show Date 1 - Current date,
else I choose Date 2 Filter the visuals computation will show Date 2 - Current date,
- Anonymous5 years ago
HI Anonymous,
You can write measure expression with if statement to check the current filter effect and navigate to different results. If you mean to create a calculated column/table based on filter selection, it is impossible.
Regards,
Xiaoxin Sheng
2 Replies
- amitchandakSuper User
Anonymous , Not very clear. You can have table with Date 1 and Date 2 has row values
assume slicer
a new measures
example measure
Switch(selectedvale(Slicer[slicer])
"Date 1" , calculate(countrows(Table), filter(Table, Table[Date1] = today())) ,
"Date 2" , calculate(countrows(Table), filter(Table, Table[Date2] = today()))
)
- AnonymousNot applicable
HI Anonymous,
You can write measure expression with if statement to check the current filter effect and navigate to different results. If you mean to create a calculated column/table based on filter selection, it is impossible.
Regards,
Xiaoxin Sheng