How to drill down in a visual using a slicer?

[markmess77]

I am essentially trying to replicate what is described in this blog post: https://blog.octanesolutions.com.au/drill-down-using-slicer-in-power-bi

However, I am currently getting an error when trying to create the new table with the following:

But I'm getting an error

Am I missing something?

[smpa01 · Accepted solution]

are you trying to create a measure . This is meant o be for creating a DAX table

[markmess77]

Wow that was stupid, yes that is what I was originally doing. Sometimes you just need a second set of eyes I guess lol thanks!

[smpa01]

No worries mate !!!!