Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter table using measure in a multiDimension DirectQuery connection to SAP

Hi All,   I have connected Power BI to SAPHana via direct query using Multidimension mode.(No calculated column, parameters allowed). only thing I can use right now is measure. I need to filter...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    not sure about your setup. 

    if you can still create a measure and table visuals, try this:

    SalesSum = 
VAR _table =
ADDCOLUMNS(
    TableName,
    "Weekday",
    WEEKDAY(TableName[Date], 2)
)
VAR _table2 =
FILTER(
    _table,
    [Weekday]<>6
    	&&[Weekday]<>7
    	&&TableName[Profit] <>0
)
RETURN
CALCULATE(SUM(TableName[Profit]), _table2)

     

    i tried and it worked like this:

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

What is your ultimate goal? If you could have such a table, what would you do next?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

My ultimate goal is to calculate the sales after filtering out both the conditions in live connection. 

Since its is Live so I cannot create a table.

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    not sure about your setup. 

    if you can still create a measure and table visuals, try this:

    SalesSum = 
VAR _table =
ADDCOLUMNS(
    TableName,
    "Weekday",
    WEEKDAY(TableName[Date], 2)
)
VAR _table2 =
FILTER(
    _table,
    [Weekday]<>6
    	&&[Weekday]<>7
    	&&TableName[Profit] <>0
)
RETURN
CALCULATE(SUM(TableName[Profit]), _table2)

     

    i tried and it worked like this: