Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a report with two visuals. One of those visuals should be filtered to show only transactions for the week selected in the date slicer, the other visual needs to show all transactions up to the date of the slicer.
For example in the below. the cash variance should only show transactions with w/e/ date 01/04/18, but the unbanked visual should be all transactions up to 01/04/18;
Any help would be appreciated.
Thanks,
Craig
Hi @CraigDon,
There is a function "Edit interactions" that can block the filtering of the slicer. But maybe you need a measure to workaround the slicer. Please share a dummy sample in order to write down the DAX formula. It could be something like this. (just a pseudo-code)
Measure = calculate(if(unbanked[date] < max('date'[rptdatewekend]), 1, 0), all('date'))
Best Regards,
Dale
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |