Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

How can I select different sizes on each drill down layer?

Hello everyone,

After interning him and not seeing how he could be, I would like to know if any of you have faced a similar situation.

I have this data table

regionWineryNamePrice

ZA134
ZA26
XB17
XB287
WC1334
WC221
ÑD134
ÑD222
&E132
&E212

What I want is to get that on each layer of the drill down, I am represented by a measurement

1COVER

And Region

X NUMBER OF WAREHOUSES

X NUMBER OF NAMES

2COVER

And names

X Price by name

To explain it more in context, I would like without selecting anything, that region appears with the count of Names and Wineries, when I mark a region, it appears all the names and the price of each bottle.

This is the measure I have created but it does not work as it should.

Nreferencias&Nbodegas = 
IF(
    ISFILTERED('VinoEspaña'[region]) || ISFILTERED('VinoEspaña'[bodega]), 
    SWITCH(
        TRUE(),
        ISINSCOPE('VinoEspaña'[region]), 
            AVERAGE('VinoEspaña'[precio]),  -- Muestra el precio promedio por bodega
        BLANK()  -- Si no hay nada seleccionado, no se muestra nada
    ),
    // Si no hay filtros aplicados, se mostrarán las cuentas distintas
    [ConteoBodegasDistintas] + [ConteoNombresDistintos]  -- Aquí puedes sumar los valores, pero lo mejor es devolver cada uno por separado en el gráfico
)


Also with the measurement of Count of Warehouses and Count of Names with distinct distinct of both.

ConteoNombresDistintos = 
IF(
    NOT(ISFILTERED('VinoEspaña'[region])) && NOT(ISFILTERED('VinoEspaña'[bodega])),
    DISTINCTCOUNT('VinoEspaña'[nombre]),
    BLANK()
)

I appreciate any help or ideas in this regard.

Thanks a lot

1 Reply

  • OktayPamuk80's avatar
    OktayPamuk80
    Responsive Resident

    Hi,

    How abount trying 2 visuals instead of 1? Could look something like this:

     

    Challenge is, as there is no conditional show/hide functionality of items (visuals, measures / columns within visuals) you can not have a native feature as you're seeking. You might work with bookmark, e.g. after selecting region, you click on the button details, and it hide the current visuals and shows the detail visual.

     

    Does it help you? Thankful to get a Kudos are mark as a Solution!
    Regards,
    Oktay