Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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,

 

  • Anonymous's avatar
    Anonymous
    5 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

  • 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()))

    )

     

  • Anonymous's avatar
    Anonymous
    Not 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