Forum Discussion
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
| Z | A | 1 | 34 |
| Z | A | 2 | 6 |
| X | B | 1 | 7 |
| X | B | 2 | 87 |
| W | C | 1 | 334 |
| W | C | 2 | 21 |
| Ñ | D | 1 | 34 |
| Ñ | D | 2 | 22 |
| & | E | 1 | 32 |
| & | E | 2 | 12 |
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
- OktayPamuk80Responsive 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