CA Moyen Dax

[nesrinehal20]

how to calculate average CA for each representative, I have representative code and invoice number and ca as data

is this code right :  

CA_Moyen_Par_Representant =

DIVIDE(

    SUM(data[CA]),

    COUNTROWS(SUMMARIZE('data', 'data'[NUM_FAC], 'data'[COD_REP]))

)

[audreygerred · Accepted solution]

Hi! You can use a quick measure. First, make your base measure; Total CA = SUM ('YourTable'[CA]). Next, open quick measures, click the drop down and select average per category. In the base value, put the Total CA measure. In Category put your field for representatives. This will give you average per rep.

Here is one I did with sample data based on average sales per country:

Sales Amount average per Country =

AVERAGEX(

    KEEPFILTERS(VALUES('Sales Territory'[Country])),

    CALCULATE([Sales Amount])

)

[Anonymous · Accepted solution]

Hi @nesrinehal20 ,

Maybe you can try formula like below:

CA_Moyen_Par_Representant =
DIVIDE (
    CALCULATE ( SUM ( data[CA] ), ALLEXCEPT ( data, data[COD_REP] ) ),
    CALCULATE ( COUNTROWS ( data ), ALLEXCEPT ( data, data[COD_REP] ) )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[audreygerred · Accepted solution]

Hi! You can use a quick measure. First, make your base measure; Total CA = SUM ('YourTable'[CA]). Next, open quick measures, click the drop down and select average per category. In the base value, put the Total CA measure. In Category put your field for representatives. This will give you average per rep.

Here is one I did with sample data based on average sales per country:

Sales Amount average per Country =

AVERAGEX(

    KEEPFILTERS(VALUES('Sales Territory'[Country])),

    CALCULATE([Sales Amount])

)