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.
hello all,
Can yo please explain logic of error.
Measure is:
Solved! Go to Solution.
HI @answeriver ,
Your syntax error is somehwere in this part of DAX:
ALLEXCEPT(
REPORT_IMS, 'REPORT_IMS'[CITY], REPORT_IMS[REGION (groups)], REPORT_IMS[VISIT MONTH]
), // you have closed the ALLEXCEPT clause here
REPORT_IMS[VISIT YEAR],'Attributes','Attributes'[type contract] // this is the line with error I guess
Question for you: What you are trying to achieve here with the line of code above?
You will have to correct your DAX something like this:
= CALCULATE(
DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE])
)
/
CALCULATE(
DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE]),
ALLEXCEPT(
REPORT_IMS, 'REPORT_IMS'[CITY], REPORT_IMS[REGION (groups)],
REPORT_IMS[VISIT MONTH], REPORT_IMS[VISIT YEAR]
),
ALLEXCEPT(
'Attributes','Attributes'[type contract]
)
)
Check if the above DAX works. Make sure to write your DAX as clean as possible - specially the closing and opening brackets.
HI @answeriver ,
Please create a new thread for this if this is something different to the syntax error issue that you raised.
HI @answeriver ,
Your syntax error is somehwere in this part of DAX:
ALLEXCEPT(
REPORT_IMS, 'REPORT_IMS'[CITY], REPORT_IMS[REGION (groups)], REPORT_IMS[VISIT MONTH]
), // you have closed the ALLEXCEPT clause here
REPORT_IMS[VISIT YEAR],'Attributes','Attributes'[type contract] // this is the line with error I guess
Question for you: What you are trying to achieve here with the line of code above?
You will have to correct your DAX something like this:
= CALCULATE(
DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE])
)
/
CALCULATE(
DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE]),
ALLEXCEPT(
REPORT_IMS, 'REPORT_IMS'[CITY], REPORT_IMS[REGION (groups)],
REPORT_IMS[VISIT MONTH], REPORT_IMS[VISIT YEAR]
),
ALLEXCEPT(
'Attributes','Attributes'[type contract]
)
)
Check if the above DAX works. Make sure to write your DAX as clean as possible - specially the closing and opening brackets.
Thank you Pragati11.
My fault with ). Actualy i need to count count of salepoint code devide on total salepoint cod with filters ALLEXCEPT. Measure from you is working without errors, but filter "type contract" whatever don't showing needs results.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |