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

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

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

    Thanks for the reply, I dont have the function Removefilters. Perhaps because I am using excel and not power bi? 

     
    • 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]) ) )