- 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.
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!