Forum Discussion

alextas's avatar
alextas
Regular Visitor
9 years ago

Visual failing to load due to function I'm not using

I work for an irrigation development company. The visual in question is a matrix with information like dam names, water storage levels, differences, and so on.   On the online report, the visual fa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi alextas,

 

Can you share some detail contents about this issue?(For e.g. datasource, connection modle, formulas...)

It is hard to reproduce your issue without any detail information.

 

In addition, you can also try to use below formula to filter non blank related records if it suitable for your requirement:

DataDamCW = CALCULATETABLE(DataDamAll, Values(Calendar[IsCurrentWeek]),ALLNOBLANKROW('DataDamAll'[Dam ID]))

 

 

Regards,

Xiaoxin Sheng

alextas's avatar
alextas
Regular Visitor
9 years ago

The data sources are a SharePoint list (dam info, the lookup table) and an Excel spreadsheet hosted on SharePoint (for the actual data). The current week data is a filtered version of the Excel data.

 

Below are the relations between the relevant tables:

- DataDamCW and InfoDam are linked on Dam ID/ID, a unique integer for each dam.

- InfoDam and DataDamAll are linked on Dam ID;

- DamDataAll and CalendarMeasures are connected on the date.

 

I'm not too sure what to include for formulas, since most of the calculated columns on each table aren't relevant for the matrix that's having issues. I've included the formula for DataDamCW in the original post.

 

Your provided formula unfortunately breaks my relationships (likely not the ones in this network), so it doesn't accept it, but thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi alextas,

     

    If you modify the 'cross filter direction' option to 'both', does this issue appears again?

    Since I can't reproduce your issue, you can also try to submit a ticket for further support.

     

    Regards,

    Xiaoxin Sheng