Forum Discussion
Incorrect Measure Total
Hi everyone! Hope you can help me this time :) I am performing the analysis and I need to show the correct total of the measure. Here is an example of the table on which I am working now...
Hi Anonymous,
Change you measure to something like this
Total test = VAR Actions = DIVIDE ( 'General'[Actions], 'General'[Total Hours], 0 ) RETURN IF ( HASONEFILTER ( 'General'[Person] ), Actions, SUMX ( ALLSELECTED ( 'General'[Person] ), Actions ) )Regards,
MFelix
Hi @dariadb,
To wha I could get from your sample file your issue is regarding the way you calculate your measures so the best way is to create the following measures:
Actions = IF ( HASONEFILTER ( Table[Name] ); DIVIDE ( [Actions Measure]; [Hours Measure]; 0 ); SUMX ( ALLSELECTED ( Table[Name] ); DIVIDE ( [Actions Measure]; [Hours Measure]; 0 ) ) )Total hours Worked Total = IF ( HASONEFILTER ( Table[Name] ); [Hours Measure]; SUMX ( ALLSELECTED ( Table[Name] ); [Hours Measure] ) )The Actions Measure and Hours Measure are your two base measures that you can use to make the calculations.
Regards,
MFelix
Hi Anonymous,
I send out a response to you message, please check it.
Regards,
Mfelix
Hi @dariadb,
To wha I could get from your sample file your issue is regarding the way you calculate your measures so the best way is to create the following measures:
Actions =
IF (
HASONEFILTER ( Table[Name] );
DIVIDE ( [Actions Measure]; [Hours Measure]; 0 );
SUMX (
ALLSELECTED ( Table[Name] );
DIVIDE ( [Actions Measure]; [Hours Measure]; 0 )
)
)
Total hours Worked Total =
IF (
HASONEFILTER ( Table[Name] );
[Hours Measure];
SUMX ( ALLSELECTED ( Table[Name] ); [Hours Measure] )
)
The Actions Measure and Hours Measure are your two base measures that you can use to make the calculations.
Regards,
MFelix