Forum Discussion

PowerPaul's avatar
PowerPaul
Icon for Helper I rankHelper I
4 years ago
Solved

What % did employee charge per module?

Hi, my data model has contractors who charge the project. The project contains many modules, each module has charges assiciated to it based on work performed.  I would like the answer in DAX but so ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You can create a measure like

    Pct charged = DIVIDE( SUM('Table'[Charges]), CALCULATE( SUM( 'Table'[Charges]), REMOVEFILTERS('Table'[Module]) ) )

    and put that in a table or matrix with the employee and module columns

  • johnt75's avatar
    johnt75
    4 years ago

    Ah, yes I don't think its available in Excel. Replace the REMOVEFILTERS with ALL, that should do the same thing

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Ah, yes I don't think its available in Excel. Replace the REMOVEFILTERS with ALL, that should do the same thing

PowerPaul's avatar
PowerPaul
Icon for Helper I rankHelper I
4 years ago

That Worked Perfectly, thank you!

Pct charged = DIVIDE( SUM('Table'[Charges]), CALCULATE( SUM( 'Table'[Charges]), ALL('Table'[Module]) ) )