Forum Discussion

CorneGeyser's avatar
CorneGeyser
Icon for Helper I rankHelper I
3 years ago

Visual Missing Data because of relationship

Hi,   I have a problem with a visual (matrix and line graphs) excluding data that has recently been added to the data source. I ma using an Excel sheet on OneDrive as the source for the data and I ...
Need Help
CorneGeyser's avatar
CorneGeyser
Icon for Helper I rankHelper I
3 years ago

It does return a result, I have validated this as well:

 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Tmp table =
CALCULATETABLE (
    '0901-SalesForecast',
    TREATAS ( { DATE ( 2023, 7, 4 ) }, 'DimCalendar'[DateID] )
)

If that produces the correct results then the problem isn't with the relationship, its somewhere else.

  • CorneGeyser's avatar
    CorneGeyser
    Icon for Helper I rankHelper I
    3 years ago

    If I use this calculation it does not return anything, but that makes sense because DATE(2023, 7, 4) will return 2023/07/04 00:00:00.

     

    If I change your calculation to the following, it returns the correct result:

    Tmp table =
CALCULATETABLE (
    '0901-SalesForecast',
    TREATAS ( { DATE ( 2023, 7, 4 ) }, 'DimCalendar'[Date] )
)

     

    Result:

     

    If it is not the relationship, what could it be? The reason I thought it was the relationship is because when the relatioship is active I do not see it in my visual (below DateID 20230704 is not here):

    but it is visible on my Data view:

    When I delete the relationship it is visible in my visual:

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      3 years ago

      The measures you have in the visual must be returning blank. Post the code for the measures and we'll see if we can work out why.

      • CorneGeyser's avatar
        CorneGeyser
        Icon for Helper I rankHelper I
        3 years ago

        I do not have any measures for this visual.

         

        The fields I have selected is all from the source table:

        Also no filters on the page or visual:

        When I create the exact same matrix on a new page it works fine. When I create a new page on the existing page, the error persists?