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.
Hello-
I am trying to have a between date range slicer filter a measure that filters a table
Here is the original Measure :
Any advice would be appreciated
Hi @westman ,
Based on your description, I created the following test data
Datestbl
MTDSalestbl
Relationship
You could try changing ALLSELECTED ( 'Datestbl'[Date] ) to ALL( 'Datestbl'[Date] )
Test Open Orders =
CALCULATE (
SUMX (
FILTER (
MTDSalestbl,
MTDSalestbl[Sequence] = "2T-Current Open Orders Grand Total"
),
MTDSalestbl[SalesPeriodT]
),
FILTER (
ALL ( 'Datestbl'[Date] ),
'Datestbl'[Date] >= MIN ( 'Datestbl'[Date] )
&& 'Datestbl'[Date] <= MAX ( 'Datestbl'[Date] )
)
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you for replying Albert, i made your suggestion change of ALL vs ALLSELECTED. However, there was no change in the output into the card visual. Same 2 dashed lines.
I am wondering if using a Min Date and Max date as a VAR in the measure may be more accurate way to write the measure instead of using FILTER. What are your thoughts?
Hi @westman ,
Thank you for your reply, the above dax function is based on the sample data I created, you can try to use the maximum date or minimum date as the filter condition, if you want more accurate help, please provide the detailed sample data and hide the sensitive information.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Side note: The measures Current Open Orders and SalesPeriodT work if I remove the date slicer, only adding the date slicer does it result in the picture above
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 |
---|---|
113 | |
103 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |