Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measures Count Blanks and Interaction Table Visual

Hi, 

 

I am making a visual related to data quality. I have multiple measurs that count how often a certain value is empty. These measures are calculated as follows:

 

Empty_column_name = COUNTBLANK('column_name')

 

I have multiple of these measures which I display in a donut chart. Below  that chart I have a table with different id numbers and some other details. What i want is to be able to click on the variable with for example 10 empty values and then see in the below table which records this considers. However, I cannot get this to interact properly... Any suggestions?

 

Even if incorporate the measure in the table (as I read in another post here) this does not help as i use multiple measures counting blank values. Any one has a suggestions on how to solve this? I am also open to approach this differently. The purpose is to see which colums/variables contain a lot of empty values and then by clicking on that part of the graph to see which records exactly this concerns so this can be checked.  I also thought about creating calculated columns instead but also this does not work. The only thing that does seem to work if i put the whole column in a grahp and then filter the visuals on empty. However this i can only do if the column at this moment contains empty values and does not work when i want combine multiple colums with each different emty rows.

 

Really curious what I am missing/doing wrong here. Also do not quite understand why it does not work even if i drag the measures in the table.. Thanks for the help in advance!

 
 
 
 

 

 

  • Hi Anonymous ,

     

     

     

    Please do like this.

    1. Replace the 'null' value with '0' in 'Edit Query'.

     

    2. Unpivot columns 'Variable2', 'Variable3', 'Variable4'.

     

    3.Create a measure.

    Please refer to my .pbix file.

     

    Note: There must be an ‘Attribute’ column in the table visual, otherwise the interaction between the two visuals can not be completed.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

5 Replies

  • Anonymous 

    Can you share some sample data and the expected result to have a clear understanding of your question?
    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
    ____________________________________
    How to paste sample data with your question?
    How to get your questions answered quickly?

    _____________________________________
    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube, LinkedIn

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, yes i replied to the message below with a better example and sample data!

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support

        Hi Anonymous ,

         

         

         

        Please do like this.

        1. Replace the 'null' value with '0' in 'Edit Query'.

         

        2. Unpivot columns 'Variable2', 'Variable3', 'Variable4'.

         

        3.Create a measure.

        Please refer to my .pbix file.

         

        Note: There must be an ‘Attribute’ column in the table visual, otherwise the interaction between the two visuals can not be completed.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Is this the problem you encountered?
    According to statistics, ID 1 has 10 blank records, but only 1 row is displayed in the table visual.

    If yes, please add an index column in 'Edit Query'.

     

    If not, please post your sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      Not exactly, what I mean is  the following:

       

       

      Here the donut chart displays three measures calculated as "Variable 2 empty = COUNTBLANK(Sheet1[Variable 2])".

       

      I want to then check what are the ids of these 4 records who have a blank field on variable 2. So I want click on that part of the donut chart and then in the table below only see the 4 ids for which variable 2 is empty.  Likewise for the other measures if selected in the donut chart.

       

      Adding the measure itself to the table does not solve the issues as there are different "empty" measures I am using.

       

      Sample Data:

       

      IDVariable 2Variable 3Variable 4
      1123aax 
      4135 x78
      1334bb 36
      4562 y87
      4567 x 
      8901 y 

       

      Thanks all for trying to help.