Hi, I have a main page for the report and two for drillthrough. I am using the following measure on the action of a button to navigate to different drill through pages if I select a visual with one measure or if I select another measure on another visual.
Drillthrough filter = var page4 = ISSELECTEDMEASURE([Total Open Risks], [Mitigated Risks])
var result = IF(page4,“Page 4”, “Page 5”) return result
What happens is that it works with only one measure, enabling the drillthrough to only one page. For example if I select the visual with the “Mitigated Risk” measure, it brings me to Page 5. If I select “Total Open Risks” the button to drill through stays disabled.
I have also tried the following:
Drillthrough filter = IF( ISSELECTEDMEASURE([Total Open Risks])," Page 4", “Page 5”)
The output is the same, it navigates to Page 5 if I select the visual with the measure “Mitigated Risks”, if I select “Total Open Risks”, the button stays disabled.
Another solution I have tried is:
Drillthrough filter = IF( ISSELECTEDMEASURE([Total Open Risks]), IF(ISSELECTEDMEASURE([Mitigated Risks])," Page 5"), “Page 4”)
What happens is that if I select “Total Open Risks”, the buttonenables and I can drill through to Page 4, if I select “Mitigated Risks”, the button enables, but it brings me to Page 4 instead of Page 5.
I have also used the following:
switch = SWITCH(TRUE(), ISSELECTEDMEASURE([Total Open Risks]), “Page 4”, ISSELECTEDMEASURE([Mitigated Risks]), “Page 5”, “”)
This measure won’t enabled the button for drill through with both measure.
Any help on how to make this measure work properly is really appreaciated.
I use two simple bar charts with Owner on the X axes and on the Y axes one of the two measures below.
Mitigated Risks = CALCULATE(COUNT(‘Risk’[Mitigated]),‘Risk’[Mitigated]=“Mitigated”, USERELATIONSHIP(‘Calendar’[Date],‘Risk’[Mitigation Date]))+0
Open Risks = CALCULATE(COUNTx(FILTER(‘Risk’,‘Risk’[Creation Date]<= max(‘Calendar’[Date]) && (ISBLANK(‘Risk’[Mitigation Date]) || ‘Risk’[Mitigation Date]> max(‘Calendar’[Date]))),[Risk ID]),CROSSFILTER(‘Calendar’[Date],‘Risk’[Creation Date],None))
| Risk id | Owner | Creation Date | Mitigation Date | Mitigated | description |
|---|---|---|---|---|---|
| 1 | owner 1 | 30/06/2022 | 31/12/2022 | Mitigated | descr1 |
| 2 | owner 2 | 30/06/2022 | Open | descr2 | |
| 3 | owner 3 | 30/06/2022 | 31/12/2022 | Mitigated | descr3 |
| 4 | owner 4 | 31/12/2022 | 30/06/2023 | Mitigated | descr4 |
| 5 | owner 5 | 31/12/2022 | 30/06/2023 | Mitigated | descr5 |
| 6 | owner 6 | 31/12/2022 | Open | descr6 | |
| 7 | owner 7 | 31/12/2022 | Open | descr7 | |
| 8 | owner 8 | 30/06/2023 | Open | descr8 |