Forum Discussion

TeisL's avatar
TeisL
Frequent Visitor
4 years ago
Solved

Only show rows when value is changed (based on date)

Hi all,   I'm fairly new in the community and I'm struggling with this issue for over weeks now. I hope somebody can help me out: I have a table with 4 columns: * WKN = my ID * AARDCONT = th...
Date
measure
values
  • johnt75's avatar
    johnt75
    4 years ago

    Needs REMOVEFILTERS

    Row Is Visible = 
var bdValues = CALCULATETABLE( VALUES( 'data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "BD", USERELATIONSHIP('Calendar'[Date], 'data'[Till]) )
var odValues = CALCULATETABLE( VALUES('data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "OD")
return IF( SELECTEDVALUE( 'data'[WKN] ) IN INTERSECT( bdValues, odValues), 1, 0)
johnt75's avatar
johnt75
Super User
4 years ago

Needs REMOVEFILTERS

Row Is Visible = 
var bdValues = CALCULATETABLE( VALUES( 'data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "BD", USERELATIONSHIP('Calendar'[Date], 'data'[Till]) )
var odValues = CALCULATETABLE( VALUES('data'[WKN]), REMOVEFILTERS(data), 'data'[AARDCONT] = "OD")
return IF( SELECTEDVALUE( 'data'[WKN] ) IN INTERSECT( bdValues, odValues), 1, 0)