Forum Discussion

mdgene's avatar
mdgene
Helper I
4 years ago

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

DateSalesColourVehicle
########10BlueFord
########15YellowDodge
########40GreenMazda
########20BlackToyota
########50WhiteFord
########30BlueDodge
########60YellowMazda
########10GreenToyota
########15BlackRenault
########40WhiteRav
########20BlueFord
########50YellowDodge
########30GreenMazda
########60BlackToyota
########10WhiteFord
########15BlueDodge
########40YellowMazda
########20GreenToyota
########50BlackRenault
########30WhiteRav
########60BlueFord
########20YellowDodge
########50GreenMazda
########30BlackToyota
########60WhiteFord
########10BlueDodge
########15YellowMazda
########40GreenToyota
########20BlackRenault
########50WhiteRav
########30BlueMazda
########60YellowToyota
########20GreenRenault
########50BlackRav
########30WhiteFord

This is a sample data

5 Replies