The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi All,
The below query doesnt work in direct query mode for Calculate and All except:
Solved! Go to Solution.
Hi @ramkula123
Calculate is not work in a calculated column in direct query. please change it to measure using below formula:
Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC])) Return MAX(Table[ColD])-a+1
Hi @ramkula123
I tried all methods as far as my knowledge, but still yet to access this because of the limitations on DAX and M code under DQ mode. I think you may change it to import mode for more performance.
Hi @ramkula123
Calculate is not work in a calculated column in direct query. please change it to measure using below formula:
Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC])) Return MAX(Table[ColD])-a+1
Hi @v-diye-msft ,
Thank you for reply. This caculation needs to be as axis in one of the visuals , but since its a measure I am not able to do so .
Is there any possible workaround for this ?
Regards
@v-diye-msft wrote:Hi @ramkula123
Calculate is not work in a calculated column in direct query. please change it to measure using below formula:
Measure = var a = CALCULATE(MIN(Table[ColD]),ALLEXCEPT(Table,Table[ColA],Table[ColB],Table[ColC])) Return MAX(Table[ColD])-a+1
Hi @ramkula123
I tried all methods as far as my knowledge, but still yet to access this because of the limitations on DAX and M code under DQ mode. I think you may change it to import mode for more performance.
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
159 | |
136 | |
133 | |
81 | |
61 |