Treatas Dax Measure error

Hi Anonymous ,

 

TREATAS() returns a table not returns the logical value ——TRUE or FALSE. Here is a example:

  

 

So , please replace the && in your expression with Comma( , )

 

 

Total Demand by Countries = 
        CALCULATE(AVERAGEX('oil_iea_ieaprodbal (Countries)','oil_iea_ieaprodbal (Countries)'[Value]),
            TREATAS(VALUES(oil_jet_jetfueldemand2[DDate]),'oil_iea_ieaprodbal (Countries)'[Date]),
            TREATAS(VALUES(oil_jet_jetfueldemand2[Region]),'oil_iea_ieaprodbal (Countries)'[Country]))

 

 

Best Regards,

Eyelyn Qin

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.