Forum Discussion

bdaodu's avatar
bdaodu
New Member
4 years ago
Solved

DAX formulas

Please help. I have a table that looks like this and woud like to calculate the following:   1. DAX formula to calculate $ for AA as % of total $ for each project. 2. DAX formula to calculate $ fo...
Need Help
  • TomMartens's avatar
    TomMartens
    4 years ago

    Hey bdaodu ,

     

    this measure

    Measure 1 = 
DIVIDE(
     SUM('Table'[$] )
     , CALCULATE(
         SUM( 'Table'[$] )
         , ALL( 'Table'[WBS Level 2] )
     )
)

    returns what you are looking for, for the 1st formula:

    Use the formatting option

     

    Hopefully, this provides what you are looking for.

     

    Regards,

    Tom

     

     

TomMartens's avatar
TomMartens
Super User
4 years ago

Hey bdaodu ,

 

please provide the expected result and explain the calculation to get the result based on the sample data you provided-

 

Regards,

Tom