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
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

As for this measure you told me to add

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

I have it added on the screen on a Card on the screen and also in the table.

When the measure is active in the table, the number of rows I see is the same as the number it shows me on the Card.

But when I turn off the measure in the table, I visually see fewer rows in the table and the same number in the Card. It takes away the one that is empty and that I should keep.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin ,

 

Please try enabling the option "Show items with no data".

 

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

    Hello

    I am not able to find that menu, where do I have to press please?

    I've been clicking on the measure etc... and I don't see it

    Thank you

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

      Hello again

      I was already able to find it and it works.

      I am very happy, thank you very much.

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

      Hello again

      I was already able to find it and it works.

      I am very happy, thank you very much.

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

        Hello again

        I have added some more columns to the order table and what is my surprise that the Time Measure is white in all rows.

        Any suggestions?