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 ...
  • 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi MFelix,

 

I have sent you a pm with a link to the pbix.  Thank you for your help with this.

 

Eric

MFelix's avatar
MFelix
Super User
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