Forum Discussion
Summarizing columns from three different date ranges(Please let me know if this the correct approah)
I have created a report that would filter based on three date ranges as below DateFilterRange = IF(MAX(vw_patientListNew[StatusDate]) in UNION(VALUES(DateRange1[Date]),VALUES(DateRange2[Da...
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
Resident Rockstar
Resident RockstarHi 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
- richbenmintz
Hi Anonymous,
Given that your date dimensions are not connected to the fact table, you will need to include the measure in your detail visual.