Forum Discussion
conditional drill through with measure
Hi
Please I have two questions on conditional drill through with measure.
1. I am trying to add a to a switch statement to check if a measure has been clicked on so that i can specify the drillthrough page
I created a button to assist with this and I have created a dax script to check if a column is chosen and direct to a certain page, but I am also trying to add a check to see if a specific measure on the stack bar is clicked (made up of measure) then a specific page should be chosen for the drill through.
My dax script
Drill Navigation =
SWITCH(
TRUE,
HASONEFILTER(Sales[Vehicle]),“page1dt”,
HASONEFILTER(‘Sales’[Colour]),“page2dt”,
“”
)
2. My second question is when I drill through on the matrix it returns all the row on the month line, even though I have added the measure to the drill through page
| Date | Sales | Colour | Vehicle |
| ######## | 10 | Blue | Ford |
| ######## | 15 | Yellow | Dodge |
| ######## | 40 | Green | Mazda |
| ######## | 20 | Black | Toyota |
| ######## | 50 | White | Ford |
| ######## | 30 | Blue | Dodge |
| ######## | 60 | Yellow | Mazda |
| ######## | 10 | Green | Toyota |
| ######## | 15 | Black | Renault |
| ######## | 40 | White | Rav |
| ######## | 20 | Blue | Ford |
| ######## | 50 | Yellow | Dodge |
| ######## | 30 | Green | Mazda |
| ######## | 60 | Black | Toyota |
| ######## | 10 | White | Ford |
| ######## | 15 | Blue | Dodge |
| ######## | 40 | Yellow | Mazda |
| ######## | 20 | Green | Toyota |
| ######## | 50 | Black | Renault |
| ######## | 30 | White | Rav |
| ######## | 60 | Blue | Ford |
| ######## | 20 | Yellow | Dodge |
| ######## | 50 | Green | Mazda |
| ######## | 30 | Black | Toyota |
| ######## | 60 | White | Ford |
| ######## | 10 | Blue | Dodge |
| ######## | 15 | Yellow | Mazda |
| ######## | 40 | Green | Toyota |
| ######## | 20 | Black | Renault |
| ######## | 50 | White | Rav |
| ######## | 30 | Blue | Mazda |
| ######## | 60 | Yellow | Toyota |
| ######## | 20 | Green | Renault |
| ######## | 50 | Black | Rav |
| ######## | 30 | White | Ford |
This is a sample data
5 Replies
- amitchandakSuper User
mdgene , You can not check measure click. You create a calculation group measure will become dimension and you can use that in drill through
Calculation Groups - Use Measure with small multiple: https://www.youtube.com/watch?v=LEn6ZnScMZc
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
- mdgeneHelper I
Thank you, will have a look through the video
- mdgeneHelper I
amitchandak looking at the video you used tabular editor . I am trying to use visual studio based on this microsoft article
Do I have to reproduce my pbi desktop datamodel into analysis service
- AnonymousNot applicable
HI mdgene,
Perhaps you can take a look at the following link to know how to find the power bi data model instance(AS tabular) then you can do these operations on visual studio side:
Connect to Power BI Desktop Model from Excel and SSMS (biinsight.com)
Regards,Xiaoxin Sheng