Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Debug card visual showing count

I have a table visual that correctly shows some filtered records. I also have a card visual that just shows the count of this table. I created the card visual by just duplicating the table visual and changing the visual type. The problem is that the card visual shows the wrong count. All of the filters are the same on the two visuals. I can't figure out how to debug the card visual because I don't know how to see the data underlying the card visual. The card visual consistently shows a higher count than the table. I have it set to count distinct, although there are no duplicates.

 

Thanks!

Need Help

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hi Anonymous 

    I can suggest that in table visual you had a row-context that affect to calcultion

    if you can it would be great to provide data example to help you

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Here's a way you can figure out what's going on.

     

    In the report, select the Card, and choose "export data"

    IF you have both options, do it twice -- export first time using "summarized data" and export second time using "underlying data".

    See if comparing the data gives you your answer.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I only have one option and it exports just the summarized count. Why is that?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous 

        You may not have permissions to the underlying data.  Or, it may be turned off for your tenant.  

        If you have permissions, open your workspace and select Settings.

         

         

         

         

         

         

         

         

        And change the selection for exporting:

         

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    It may be that the context affects the filter conditions.

    Cloud you share the sample data and the DAX formula?(It is better to share sample .pbix after masking any sensitive data)

     

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