Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
So I understand that you want to either show or not show the Name2 measure. But what specifically do you want to show?
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).
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |