Forum Discussion

games1's avatar
games1
Frequent Visitor
8 years ago
Solved

Any help here

On the table below, starting from Account till Descritpion (I will keep appending data) and i would need to use them as filter on the visualization.   I want to calculate Cost 1% and Cost 2 % - Mat...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi games1,

     

    If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

    Cost 1% =
DIVIDE (
    CALCULATE (
        SUM ( 'Table1'[Value] ),
        FILTER ( 'Table1', 'Table1'[Split] = "Cost 1" )
    ),
    CALCULATE (
        SUM ( 'Table1'[Value] ),
        FILTER ( ALL ( 'Table1' ), 'Table1'[Split] = "Cost 1" )
    )
)

    Note: You'll need to replace 'Table' and [Value] with your real table name and column name.

     

    Regards

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

Hi games1,

 

If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

Cost 1% =
DIVIDE (
    CALCULATE (
        SUM ( 'Table1'[Value] ),
        FILTER ( 'Table1', 'Table1'[Split] = "Cost 1" )
    ),
    CALCULATE (
        SUM ( 'Table1'[Value] ),
        FILTER ( ALL ( 'Table1' ), 'Table1'[Split] = "Cost 1" )
    )
)

Note: You'll need to replace 'Table' and [Value] with your real table name and column name.

 

Regards