Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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

  • MFelix's avatar
    MFelix
    7 years ago

    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

     

MFelix's avatar
MFelix
Super User
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi MFelix,

     

    Thank you for your solution!

    However it gives me a strange total:

    • affan's avatar
      affan
      Solution Sage
      7 years ago

      Hi Anonymous

       

      Can you share some base data or the pbix

       

      Regards

      Affan

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Unfortunately I can't share it due to confidentiality

    • MFelix's avatar
      MFelix
      Super User
      7 years ago

      Hi Anonymous,

       

      I send out a response to you message, please check it.

       

      Regards,

      Mfelix

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        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