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

Thanks for that insight.  I didn't realize that Power BI would ignore the entire record in such situations.   Other tools will either not consider the record in the calculation or assume its 0.

 

I used the merge option because Power BI won't allow you to create many to many relationships which exists all over my data.  This data is transactional in nature and not aggregated.  I flatten it wherever possible, but that isn't always the case.  Also power BI didn't allow me to utilize data from all 4 datasets in the report.  I could only use 2 without an error.  When I searched on the error I was receiving, Microsoft documentation indicated this to be expected behavior.  If I was dealing with aggregate tables or KPIs, this probably wouldn't be a problem, but all of the data is one to many, which doesn't work as I would expect.

 

To be honest, I would prefer to create relationships as opposed to merging the data, that way I would be able to reuse more datasets.  Unfortunately this does not appear to be a possibility without improvements to Power BI.

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

The many to many relationships can be worked with dimension table to make the links between the several tables and using the bidirectional filters.

 

Not really sure how you hacve your data model but if you need any help please share some insights on it so we can see together how you can do it.

 

Regards,

MFelix