Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |