Forum Discussion

Pens_87's avatar
Pens_87
New Member
3 years ago

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

  • So I understand that you want to either show or not show the Name2 measure. But what specifically do you want to show?

    • Pens_87's avatar
      Pens_87
      New 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).