Forum Discussion
Chart Drilldown - Using different data sources at each level
I am working from a table which has the below structure: I would like to create a drilldown visual where each layer looks at the total numeric value based on that selection. For example: ...
Hi Anonymous thank you for responding. Unfortunately your meothod doesn't work. Here is a link to my sample dataset -
https://docs.google.com/spreadsheets/d/1AU70ei1Oi7bfMSf0vMtxU9DY1mGlIx1bYkPQHJ7eJKM/edit?usp=sharing
The blow is the measure which I created which almost appears to work
RETURN
SWITCH(TRUE()
----COUNTRY
,HASONEVALUE(Consolidated_LLMIT[national_3]) && HASONEVALUE(Consolidated_LLMIT[region]) = FALSE(),
CALCULATE(SUM(Consolidated_LLMIT[numeric_value]),Consolidated_LLMIT[data_level] = Consolidated_LLMIT[national_3])
----REGION
,HASONEVALUE(Consolidated_LLMIT[region]) && HASONEVALUE(Consolidated_LLMIT[county]) = FALSE(),
CALCULATE(SUM(Consolidated_LLMIT[numeric_value]),Consolidated_LLMIT[data_level] = Consolidated_LLMIT[region])
----COUNTY
,HASONEVALUE(Consolidated_LLMIT[county]) && HASONEVALUE(Consolidated_LLMIT[local_authority]) = FALSE(),
CALCULATE(SUM(Consolidated_LLMIT[numeric_value]),Consolidated_LLMIT[data_level] = Consolidated_LLMIT[county])
----LOCAL AUTHORITY
,HASONEVALUE(Consolidated_LLMIT[local_authority]),
CALCULATE(SUM(Consolidated_LLMIT[numeric_value]),Consolidated_LLMIT[data_level] = Consolidated_LLMIT[local_authority])
,0)