Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |