Forum Discussion

balumaran's avatar
balumaran
Frequent Visitor
9 years ago

Conditional Columns or IF Conditions in Direct Query mode

Hello Experts,  Looking for help here. I have a report that pulls data from 11 mil rows and 10 mil rows SAP HANA views in direct query mode. I understand that there are limitations in Direct Query m...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

balumaran,

 

For your Dimensional attrinbute, it's better to create a column other than a measure. I have tested it on my local environment, connect to SAP HANA.

Column = IF(RaduSales[EnglishProductName]="Bikes","A","B")
Measure 2 = if(SUM(RaduSales[SalesAmount])>50000000,"Good","N/A")

 

If your issue persists, please provide us more detail information, so that we can make further analysis.

 

Regards,

Charlie Liao

balumaran's avatar
balumaran
Frequent Visitor
9 years ago

Thanks Charlie for getting back to me. 

 

I am trying to create a measure based on a dimensional attribute, so When I create a measure , in If statement under Logical Test, my dimensional attribute column is not getting listed and it does not allow me to select it as well. I have to have an aggregation like Max, MIn, Distinct with the attribute with in the If statement.

 

I have a table with Attribute column account code, measures Attendance columns, dates etc. I need to create a paid attendance measure based on Account code. If account code is 4000, then sum(Attendance) is the Paid attendance. 

 

What am I missing ?