Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Show Data Point As A Table with a measure

Hi, I have a client that loves the show data point as a table feature.  I am a bit frustrated because you create these great measures and can't use them in the show data point as a table.   Does a...
axecap's avatar
axecap
Frequent Visitor
3 years ago

I echo this. I don't fully get why I can see the data behind a table/visual UNTIL I add a measure. I guess this is about measures not being calculated for each row. But surely you should be allowed to see the other data points (and just not show the measure). Frustrating. 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You can experiment with some cross joins and observe how adding a measure changes the outcome. That will give you an idea of the mechanics behind the scenes.

    • axecap's avatar
      axecap
      Frequent Visitor
      3 years ago

      Could you elaborate on what you mean as I'm new to PowerBi, adding a measure changes the outcome of what? I think I'm missing something fundamental here.

      What I don't understand is if I have a table of calculated columns, I can see the "data point is a table". But adding a measure disables that? Surely it's the same data underneath and either way, couldn't it just ignore the measure and still show me the data it would have shown before i added the measure

      Vs

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        I would consider that to be confusing for the report users as it introduces inconsistencies in the UX. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com