Forum Discussion

dagurkuden's avatar
dagurkuden
Frequent Visitor
8 years ago
Solved

Some dax functions does not work on PBRS

Hi all; Some functions does not work  like dateadd,totalmtd,totalytd etc.  in direct query mode   And I  wanna say everthing works at Power BI Desktop RS .The problem starts when I published  to t...
dax functions
measure
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi dagurkuden,

     

    I got information that unfortunately we do not have any information on road map to consider near future. I would request to create comment on forum https://ideas.powerbi.com/forums/265200-power-bi , So that product team will consider the same based on priority and requirement.

     

    Regarding the error, please double check if the Allow unrestricted measures in Direct query mode option is enabled. Also as the Values() function return in a column of unique values, please modify the measure like below: 

     

    Measure = CALCULATE(SUM('Product'[Amount]),FILTER(ALL('DateVal'),'DateVal'[DateCol] in VALUES(DateVal[DateCol])))

    or

    Measure 2 = CALCULATE(SUM('Product'[Amount]),ALL(DateVal),VALUES(DateVal[DateCol]))

     

    As I tested, it can work fine both in desktop and report server. 

     

     

    Best Regards,
    Qiuyun Yu

dagurkuden's avatar
dagurkuden
Frequent Visitor
8 years ago

hi v-qiuyu-msft

 

You are right that filter function is working.

 

But when I associated this with a bit of time data, I am getting this error

 

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi dagurkuden,

 

I got information that unfortunately we do not have any information on road map to consider near future. I would request to create comment on forum https://ideas.powerbi.com/forums/265200-power-bi , So that product team will consider the same based on priority and requirement.

 

Regarding the error, please double check if the Allow unrestricted measures in Direct query mode option is enabled. Also as the Values() function return in a column of unique values, please modify the measure like below: 

 

Measure = CALCULATE(SUM('Product'[Amount]),FILTER(ALL('DateVal'),'DateVal'[DateCol] in VALUES(DateVal[DateCol])))

or

Measure 2 = CALCULATE(SUM('Product'[Amount]),ALL(DateVal),VALUES(DateVal[DateCol]))

 

As I tested, it can work fine both in desktop and report server. 

 

 

Best Regards,
Qiuyun Yu