Help with to Total a Measure of a Measure total

[jprousseau]

Hi there

can someone please help me with to total a measure of a measured column.

The m_DailyTarget which is a multiplication of 2 measues does not want to add up in total column.

Please see the screenshot of all the dax and fields.

Thanks

[Angith_Nair · Accepted solution]

Hi @jprousseau ,

Change three measures like this..

m_DaysSelected = 
SUMX (
    VALUES ( NBAdminTasks[assignedtodisplayname] ),
    CALCULATE ( DISTINCTCOUNT ( NBAdminTasks[completiontime - Date only] ) )
)


m_DailyTarget = 
SUMX (
    VALUES ( NBAdminTasks[assignedtodisplayname] ),
    CALCULATE ([m_DaysSelected]* [m_DailyTasks])
)


m_AveTaskTarget% = 
SUMX (
    VALUES ( NBAdminTasks[assignedtodisplayname] ),
    CALCULATE ([m_TaskCount]/[m_DailyTarget] *100 )
)

Please find the pbix file here .
If this works then please mark this as a solution. Appreciate with Kuddos.

[jprousseau]

Thank you it worked. Just changed the last measure to AVERAGEX

m_AveTaskTarget% = 
AVERAGEX (
    VALUES ( NBAdminTasks[assignedtodisplayname] ),
    CALCULATE ([m_TaskCount]/[m_DailyTarget] *100 )
)

[Angith_Nair]

Hi @jprousseau ,

Try to use this measure...

m_DailyTarget =
SUMX ( NBAdminTasks, 'NBAdminTasks'[m_DaysSelected] * [m_DailyTasks] )

m_AveTaskTarget% =
AVERAGEX ( NBAdminTasks, [m_TaskCount] / [m_DailyTarget] )

If this works, kindly mark it as a solution. Appreciate with kuddos.

[jprousseau]

not working 

[jprousseau]

[amitchandak]

@jprousseau , can you share the formula in text format

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[jprousseau]

Where can i copy/drop the file to?

Thanks

[Angith_Nair]

You can upload it to google drive or dropbox or One drive and share the link here...