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)
TeisL's avatar
TeisL
Frequent Visitor
4 years ago

Hi johnt75 ,

 

Thank you for your feedback and coorporation!

Unfortunately, I'm not quiet there...

 

The result is showing all the ID's where an OD started. I only need to see the ID's where the value changed from BD to OD.
Do you think this is feasible as well?

I added the calender:

Results:

 

Let me know if I should change something.
Thanks!

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try

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