Forum Discussion
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 ...
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.
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!
You are welcome.