Forum Discussion

kostal's avatar
kostal
New Member
6 years ago

Table column considering a slider filter

Hi,   I am trying to  find out if there is possible to create a column that will calculated its value dynamicly on based of a date slider filter. I tried lot of approches but no of them was success...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi kostal ,

 

Please create a measure as below instead of a calculated column.

Measure = 
VAR c =
    CALCULATE (
        COUNTROWS ( AllData ),
        FILTER (
            ALLSELECTED ( AllData ),
            AllData[DateTime] <= MAX ( AllData[DateTime] )
        ),
        VALUES ( AllData[ID] )
    )
VAR c_ =
    CALCULATE (
        COUNTROWS ( AllData ),
        ALLSELECTED ( AllData ),
        VALUES ( AllData[ID] )
    )
RETURN
    IF ( c = c_, TRUE (), FALSE () )

 

Pbix as attached.