Forum Discussion
Summarizing columns from three different date ranges(Please let me know if this the correct approah)
The site doesn't let me upload file.
Data:
| StatusDate | InterventionType |
| 7/21/1989 0:00 | Interventional TX |
| 1/8/1990 0:00 | Interventional TX |
| 4/30/1990 0:00 | Interventional TX |
| 11/3/2006 0:00 | Interventional Non TX |
| 11/6/2006 0:00 | Interventional TX |
| 11/8/2006 0:00 | Interventional Non TX |
| 11/9/2006 0:00 | Interventional TX |
| 11/13/2006 0:00 | Interventional TX |
| 11/14/2006 0:00 | Interventional Non TX |
| 11/14/2006 0:00 | Interventional TX |
| 11/15/2006 0:00 | Interventional Non TX |
| 11/16/2006 0:00 | Interventional TX |
| 11/17/2006 0:00 | Interventional Non TX |
| 11/20/2006 0:00 | Interventional TX |
| 11/22/2006 0:00 | Interventional Non TX |
| 11/22/2006 0:00 | Interventional TX |
| 11/27/2006 0:00 | Interventional TX |
| 11/28/2006 0:00 | Interventional Non TX |
| 11/28/2006 0:00 | Interventional TX |
| 11/30/2006 0:00 | Interventional Non TX |
| 11/30/2006 0:00 | Interventional TX |
| 12/1/2006 0:00 | Interventional Non TX |
| 12/1/2006 0:00 | Interventional TX |
| 12/4/2006 0:00 | Interventional TX |
| 12/5/2006 0:00 | Interventional TX |
| 12/6/2006 0:00 | Interventional TX |
| 12/7/2006 0:00 | Interventional TX |
| 12/11/2006 0:00 | Interventional Non TX |
| 12/11/2006 0:00 | Interventional TX |
| 12/12/2006 0:00 | Interventional Non TX |
| 12/12/2006 0:00 | Interventional TX |
| 12/13/2006 0:00 | Interventional Non TX |
| 12/14/2006 0:00 | Interventional TX |
| 12/15/2006 0:00 | Interventional Non TX |
| 12/18/2006 0:00 | Interventional Non TX |
| 12/19/2006 0:00 | Interventional Non TX |
| 12/19/2006 0:00 | Interventional TX |
| 12/20/2006 0:00 | Interventional Non TX |
| 12/20/2006 0:00 | Interventional TX |
| 12/21/2006 0:00 | Interventional Non TX |
| 12/21/2006 0:00 | Interventional TX |
| 12/22/2006 0:00 | Interventional Non TX |
| 12/27/2006 0:00 | Interventional TX |
| 12/28/2006 0:00 | Interventional TX |
| 1/2/2007 0:00 | Interventional Non TX |
| 1/4/2007 0:00 | Interventional TX |
| 1/5/2007 0:00 | Interventional Non TX |
| 2/24/2020 0:00 | Interventional Non TX |
| 2/24/2020 0:00 | Interventional TX |
| 2/25/2020 0:00 | Interventional Non TX |
| 2/25/2020 0:00 | Interventional TX |
| 2/26/2020 0:00 | Interventional Non TX |
| 2/26/2020 0:00 | Interventional TX |
| 2/27/2020 0:00 | Interventional Non TX |
| 2/27/2020 0:00 | Interventional TX |
| 2/28/2020 0:00 | Interventional Non TX |
| 2/28/2020 0:00 | Interventional TX |
| 3/1/2020 0:00 | Interventional Non TX |
Desired Results :
| Slicer1(1/1/1989 - 7/26/1990) | Slicer2(11/3/2006 - 1/5/2007) | Slicer3(2/24/2020-3/1/2020) | |
| Interventional TX | 3 | 24 | 5 |
| Interventional Non TX | 0 | 20 | 6 |
I have three slicers:
Resident RockstarHi Anonymous
Please have a look at the .pbix file created.
I contains 4 measures:
Slicer 1 Value = CALCULATE(COUNTROWS('Table'), 'Table'[StatusDate] in VALUES('slicer 1'[Date]))
Slicer 2 Value = CALCULATE(COUNTROWS('Table'), 'Table'[StatusDate] in VALUES('slicer 2'[Date]))
Slicer 3 Value = CALCULATE(COUNTROWS('Table'), 'Table'[StatusDate] in VALUES('slicer 3'[Date]))
Total Slicer Value Selection = [Slicer 1 Value] + [Slicer 2 Value] + [Slicer 3 Value]
which evaluate to the values you are looking for
Hope this helps
richbenmintz Yes this the result I was expecting but when I click on the slicer 2 value and "Interventional Non TX" which has 7 counts should only display 7 but display the entire row count 13. Is there a way to display only 7 in detail report? should I use a matrix ? please suggest
- richbenmintz
Hi Anonymous,
Not really sure what you mean selecting the value in the table created it does not filter the table, what detail visual are you referring to
Hi richbenmintz i am referring to another table visual I added that contains a list of statusdate and intervention type