Discouraged Implicit Measures - missing Show Data Point as Table

[DavidKovarik]

Hello all,

as I wanted to use Calculation Groups, I was forced to switch on Discouraged Implicit Measures. The problem is that with Explicit Measures (the ones I created instead of Implicit ones), when I use them on visuals (bar charts, line charts, but even matrix table) the "Show data point as table" feature is not available.

So my question is - is there a way how to use "Show data point as table" feature without Implicit Measures? Thanks a lot.

Regards,

David 

[Alex87 · Accepted solution]

Hello, 

You should always use explicit measures instead of implicit ones ( reusability, consistency, documentation).

Implicit measures are fine for quick ad-hoc prototyping or personal exploration.

To answer your question, you can create a dedicated drillthrough page with a Table visual showing all the columns you care about. That gives you row-level visibility, even though you’re using an explicit DAX measure.

Best regards,

Alex

[DavidKovarik]

Thanks Alex for the quick response and additional recomendations about measures.

The main purpose why we are using "Show data point as table" in our company is exporting "raw" data into the Excel, but I can see this should be possible in Table visual as well :). Will go with this solution then.

Thanks again!

[LED_General]

This is the way!