Forum Discussion
Manipulate rows with Measure by selected date
I'm trying to manipulate a visualization table using a Measure. The "Report Date" column below currently represents a Measure called [Report Date] which reflects the date specified by a slicer.
My goal is to create a new Measure (e.g. "Name2") that will compare the [Report Date] Measure to the "Removed Date" field. If the Removed Date is either greater than [Report Date] or is equal to 0, then I want the new "Name2" Measure to appear in the visualization. If that criteria is not met, then I want the Name2 row to be excluded from the visualization entirely.
Sample Data
Name Total Calls Report Date Removed Date
Name 1 50 3/31/2023
Name 2 100 3/31/2023 9/1/2020
Name 3 80 3/31/2023 4/30/2023
Name 4 75 3/31/2023 1/31/2023
Name 5 75 3/31/2023
Desired Result
Name2 Total Calls Report Date Removed Date
Name 1 50 3/31/2023
Name 3 80 3/31/2023 4/30/2023
Name 5 75 3/31/2023
I'm trying to use a Measure here rather than a Calculated Column or Page Filter because I want to maintain the dynamic capability through the [Report Date] Measure.
2 Replies
- AnthonyGenovese
Resolver III
So I understand that you want to either show or not show the Name2 measure. But what specifically do you want to show?
- Pens_87New Member
My goal is to replicate the "Desired Result" table that I show in my original post (that's the visualization output I'm going for).