Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need to crete filter by week ranges
Now
Range =
but when i select whool range i got error in visuals or do not showing info at all
Error Message:
MdxScript(Model) (332, 13) Calculation error in measure 'DK'[rate %]: An argument of function 'DATE' has the wrong data type or the result is too large or too small.
TY, your post is not helpful
@Analitika , rate % seems correct. Unless there is an error Range. Can you check them separately.
error only if whoole group of week select, if selected week separately everithing work
All looks ok , are you using date in measures of [LY] or [CountS] seems like problem happening at these measures.
Proud to be a Super User!
countS =
ROUND (
CALCULATE (
CALCULATE ( SUM ( [sum2] ) ),
FILTER (
'T1',
'T1'[Table] = "t"
&& NOT 'T1'[item] IN { "1", "2", "3" }
)
),
0
)
No matter which measure, every measure return empty if whoole weeks range selected, and return sums if selected separetly weeks
Hi @Analitika ,
Please check if this post helps:
An Argument of Function Date has wrong data type or result is too small or too large Error
In addition, are [sum] and [sum2] measures? If they are, need to use SUMX inteading of SUM function.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |