Calculate subtotal with DAX

[Anonymous]

Hi everyone,

I'm trying to perform a formula to calculate a subtotal of the "Nb Answered" but cannot achieve it...

What I want exactly is the % of "Nb Answered" for each agent, obviously by date. So I have to calculate the sum of "Nb Answered", by date. 

Can someone help ?

Thank you very much in advance

Ben

[amitchandak]

You can do in Matrix Visualization

Refer for formula

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

https://www.tringuyenminh92.com/index.php/2017/08/07/percent-of-subtotalgroups-in-power-bi/

[Anonymous]

Hi Amitchandak, Is there a way to do it in a table as I have other columns and the matrix does not correspond the requirements I have. I tried this formula without success : % of calls = CALCULATE ( SUM ( 'User Productivity'[Nb Answered] ) ) / CALCULATE ( SUM ( 'User Productivity'[Nb Answered] ); ALLEXCEPT ( 'User Productivity'; 'User Productivity'[Agent] ) ) I'm I doing Something wrong, or is it just because of the vizualisation ? Thank you !

[amitchandak]

I tried sameon table . For Sub total at brand level, I sorted table on brand to check results 

% Brand = 
CALCULATE ( SUM ( Sales[Sales] ) )
    / CALCULATE (
        SUM ( Sales[Sales] ),
        ALLEXCEPT ( 'Item','Item'[Brand])
    )*100

[amitchandak · Accepted solution]

If you want at the date level then the date should have driven denominator?

[Anonymous]

Ok I got it !! Thank you very much !!!!!