Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Create the relationship between 2 tables in the data model

Good afternoon I have created a Calendar Table as follows: Calendar = where _cal = CALENDAR(MIN('Orders'[Start_Date]), MAX('Orders'[End_Date])) return ADDCOLUMNS(_cal,"Year", YEAR([Date]), "Mo...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    Hello

    Troubleshoot the problem. In this measure of time in the AllSELECTED function you add all the columns that you are going to show in the report.

    Time Measure =
    WHERE SelectedTable =
    FILTER (
    ALLSELECTED ( Orders[Start Date], Orders[End Date],Orders[ID_BATCH],Orders[SIG_BY_ID] ),
    Pmx[End Date] <> BLANK ()
    )
    WHERE CurrentStart = MAX ( Pmx[Start Date] )
    WHERE PreviousDatesTable = FILTER ( SelectedTable, Pmx[Start Date] < CurrentStart )
    WHERE PreviousEnd = MAXX ( PreviousDatesTable, Pmx[End Date] )
    WHERE FirstSelectedDate = MINX ( PreviousDatesTable, Pmx[CPK_SIG_TIMESTAMP] )
    WHERE TimeDifference = DATEDIFF ( PreviousEnd, CurrentStart, MINUTE )
    WHERE Result = DIVIDE ( TimeDifference, 60, " " )
    RETURN
    Result
    Thank you for the help you have given me, thank you very much
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin ,

 

Please try the measure and show items when it is not blank.

 

Measure = 
COUNTROWS (
    FILTER (
        Orders,
        Orders[Start_Date].[Date] >= MIN ( 'Calendar'[Date] )
            && Orders[End_Date].[Date] <= MAX ( 'Calendar'[Date] )
    )
)


If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    I have added the measure and the same thing continues to happen to me. If I have it active it comes out like this

    And if I remove the measure now I lose the first and second row

    I need that when I deactivate the measure that I do not need to visualize in the table, the records of the Table continue to look as if there were

    Thank you and I look forward to it