Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Select a single cell in table

Helo everyone,

 

I have created few DAX measures which shows counts of various categories. I want user to click on certain cell so that they can see more details of the count on another table below. But the thing is whenever I click the whole row is getting selected and in another table I am getting all the values. 

 

I searched previous solutions many said it's not possible, is there any other alternative way to achieve?

 

 

Thanks,

Karthik

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix  Your thoughts on this?

     

     

    The metrics that you can see in table-1 are calculated from DAX and these are shown based on milestones. The table-2 shows a detailed information without any sort of aggregation (source for table-1). 

    My requirement is if someone clicks on any number in table-1, automatically those records must be shown in table-1. As of now filter is happening based on rows (milestone) but I need the filter to work on the basis of counts (cell).

     

    Is this possible to achieve?

     

    Thanks,

    Karthik

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous ,

       

      This is related with the configuration of your matrix. When you add measure to a matrix you get a column visualization however there is no "column context" (probably not the best word) and when you select the values you are only getting the values where there is "context" in this case the row see image below:

       

       

      Has you can see since I don't have column I can only select the entire row.

       

      If you add a disconnected table with the measures names and a switch measure you can select individual cells since the "column context" is added to the matrix.

       

      What I did in my case was to create the following table and measure:

       

      SalesMEasuresValues = SWITCH(
                    SELECTEDVALUE(SalesMeasures[ID]),
                    1, [sales previous year],
                    2, Sales[sales previous year])

       

      Now you need to use the measure has values on the matrix and the column no the table on the columns, also you need to add the measure to filter out the table visualization showing all the values that are not blank:

      Has you can see now you can select individual values. In my case the calculations are very simple but in other models I was abble to filter out a list of customer based on the values of sales between certains min and max.

       

      Check PBIX file attach.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank you MFelix  but will the solution work if we have multiple DAX measures?