Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon
I have created a Calendar Table as follows:
Calendar =
The orders table is as follows:
I have created a DatePicker whose values are linked to the Calendar table where the user can select a range of dates between Start_Date and End_Date. The problem I am having is that I need to create the relationship between both tables because when I select the values in the DatePicker the selection is not made between the selected dates.
How should I create the relationship in the model? I don't know how to relate the Date field to the order table with both Start_Date and End_date.
Thank you very much in advance
Solved! Go to Solution.
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.
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.
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.
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
Hello again
I was already able to find it and it works.
I am very happy, thank you very much.
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?
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.
Hello again
I was already able to find it and it works.
I am very happy, thank you very much.
In case it is useful for you, here I leave the Calendar table as I have created it:
And this is the measure linked to the table that was simply to check that the records that are returned to me are with value 1, since the selected ranges are always going to be within date range.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |