Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

empty report when filtering

I am building a report where I seem to have a filter that I can't find. When I apply filtering on some values in my visual level filters, I get an empty report returned

 

 

When I go to the data view, I can see that the data exists.  

 

To the best of my knowledge I can't find any filters anywhere in the report.  Any suggestions on what could cause such a scenario or where to look?

 

Thanks!

 

  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    the question is your Open Debt colum, you are using a summarize option (SUM) in this case this is calculating the sum of the values however for the specif code you are refering  of Banner ID that column is null in this case this don't sum as 0 since all values as null it doesn't appear on your table.

     

    If you go to your last column in the table and select the don't summarize the A00010140 will appear but with blank / null values.

     

    One question I didn't understood why are you appending merging all you table into a giant one and not making relationship between tables and uisng measure to make your calculations?

     

     

    Regards,

    MFelix

8 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Anonymous,

     

    Looking at the images you attached, you have Blanks in the BannerID is this correct or this column should have always ID's?

     

    Asking this because you can be having this result if this column is related with other in your model and there are some values missing from your dimension table, then when you filter out the result it gives you blanks.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       

      Hi MFelix,

       

      Thanks for weighing in,

       

      The blank values are correct in the way the query is currently written.  A change to the view to be left outer on a few tables will resolve that issue.  

       

      This although is unrelated to my current issue.  When filtering on the value A00010140 I receive an empty report, but the data clearly shows as available in the data view.  

       

      In the case of how this data is structured, I have merged my queries into one.  The functionality of data sets is rather limiting and would not allow for a star schema due to unavoidable 1 to many situations in the data.

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi Anonymous,

         

        Can you share the PBIX file so that I can check it out, if you want due to sensitivity of data you can do it through private message.

         

        Regards,

        MFelix