Forum Discussion

aasamassa's avatar
aasamassa
Advocate I
8 months ago
Solved

Issue with visual not showing some data for specific year, while the measure displays the total

I have a table for quotas and a central table for the dates. They are joined by the columns 'quota's year' and 'Date'. Below are sow extracts of the two tables and how they are linked. Rep ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 months ago

    Hi,

    Expand the filter pane to ensure that there is no active filter.  Also, if there is already an active relationship between the Quote year and Dae column, why are you using the TREATAS() functiona at all.  A simple SUM() function should work.

    If neither helps, then please share the download link of the PBI file.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 months ago

Hi,

Expand the filter pane to ensure that there is no active filter.  Also, if there is already an active relationship between the Quote year and Dae column, why are you using the TREATAS() functiona at all.  A simple SUM() function should work.

If neither helps, then please share the download link of the PBI file.

aasamassa's avatar
aasamassa
Advocate I
8 months ago

There was indeed an active filter. For some reason, even though that filter was referring to another table, it was preventing the number to be displayed. 

I added the Treatas() function just to see if it would help, at first i just had the sum() function.

 

Thanks for your help!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 months ago

    You are welcome.