Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 and the column which I should calculate. This column is a measure (actions/hours). 

 

I tried to use this formula but ot doesnt give the correct total.

 

Total test =
var Actions = DIVIDE('General'[Actions],'General'[Total Hours],0)
return if
(HASONEFILTER('General'[Person]), Actions, sumx(values('General'[Person]),actions))
 
Thank you!!

 

action per hour.PNG

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

8 REPLIES 8
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Hi @MFelix,

 

Thank you for your solution!

However it gives me a strange total:

Total.PNG

Hi @Anonymous,

 

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

 

Regards,

Mfelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi @Anonymous

 

Can you share some base data or the pbix

 

Regards

Affan

Anonymous
Not applicable

Unfortunately I can't share it due to confidentiality

ryan_mayu
Super User
Super User

@Anonymous

 

What's the purpose of using hasonefilter formula? I think  DIVIDE('General'[Actions],'General'[Total Hours],0) can work correct.

 

Thanks and BR

Ryan





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Because using just divide function it doesnt show the correct total of the column. 

As there is a Person filter (for each row) I used hasonefilter to calculate total. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.