Forum Discussion

GellaiTamas's avatar
GellaiTamas
Helper I
8 years ago
Solved

DAX_Filtered division within one column

Hi,   I have many columns in an SQL DB table and these 2 among them: [Property] and [Value].  [Property] has ~30 different items. How can I divide only 2 specific properties? I'm not quite sure ho...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    GellaiTamas,

     

    Hi Tamás,

     

    We can evaluate the totals separately. Try this formula please.

    InflationPerCostBase =
VAR AOPInflation =
    CALCULATE (
        SUM ( 'Report1 (2)'[Value] );
        'Report1 (2)'[Property] = "AOP Inflation"
    )
VAR AOPCostBase =
    CALCULATE (
        SUM ( 'Report1 (2)'[Value] );
        'Report1 (2)'[Property] = "AOP Cost Base"
    )
RETURN
    DIVIDE ( Inflation; CostBase; 0 )

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

GellaiTamas,

 

Hi Tamás,

 

We can evaluate the totals separately. Try this formula please.

InflationPerCostBase =
VAR AOPInflation =
    CALCULATE (
        SUM ( 'Report1 (2)'[Value] );
        'Report1 (2)'[Property] = "AOP Inflation"
    )
VAR AOPCostBase =
    CALCULATE (
        SUM ( 'Report1 (2)'[Value] );
        'Report1 (2)'[Property] = "AOP Cost Base"
    )
RETURN
    DIVIDE ( Inflation; CostBase; 0 )

Best Regards!

Dale

  • GellaiTamas's avatar
    GellaiTamas
    Helper I
    8 years ago

    Hi v-jiascu-msft,

     

    Great stuff, it works. Thanks a million!

     

    Cheers,

    Tamás