Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |