- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-19-2018 06:12 AM

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**=

Solved! Go to Solution.

Accepted Solutions

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-19-2018 07:26 AM

Hi @dariadb,

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

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

Proud to be a Datanaut!

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-26-2018 06:59 AM

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

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

Proud to be a Datanaut!

All Replies

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-19-2018 06:55 AM

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

Thanks and BR

Ryan

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-19-2018 07:11 AM

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.

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-19-2018 07:26 AM

Hi @dariadb,

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

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

Proud to be a Datanaut!

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-20-2018 12:24 AM

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-20-2018 12:32 AM

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-20-2018 01:19 AM

Unfortunately I can't share it due to confidentiality

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-20-2018 02:01 AM

Hi @dariadb,

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

Regards,

Mfelix

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

Proud to be a Datanaut!

## Re: Incorrect Measure Total

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-26-2018 06:59 AM

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

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

Proud to be a Datanaut!