User Profile
answeriver
Helper IV
Joined 7 years ago
User Widgets
Contributions
Re: Error cannot convert value of type text to type true false
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. Measure 5 = 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],REPORT_IMS[UNIVERSE]),ALLEXCEPT(Attributes,Attributes[Type of Contract])) Measure 7 = CALCULATE(DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE])) Measure 8 = CALCULATE(DISTINCTCOUNT(REPORT_IMS[SALEPOINT CODE]),ALLEXCEPT(REPORT_IMS,'REPORT_IMS'[CITY],REPORT_IMS[REGION (groups)],REPORT_IMS[VISIT MONTH],REPORT_IMS[VISIT YEAR],REPORT_IMS[UNIVERSE]),ALLEXCEPT(Attributes,Attributes[Type of Contract]))
