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

# Total multiplied by rows in measure

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

12-07-2018 06:19 AM

having the following columns :

The right column is a measure with the following code:

Solved! Go to Solution.

Accepted Solutions

## Re: Total multiplied by rows in measure

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

12-07-2018 06:36 AM

Its is due to the scope of the filters.

Try creating a new measure with this check = hasonefilter(somecolumn) and add it to your table to find out which column has filter and not on the total value.

Then you can wrap your measure for ticket price into if(hasonefilter(filteredcolumn);do something; dosomething else)

see this video as well explaining why this is happening:

https://www.youtube.com/watch?v=Ka7Ds4EAjNQ

All Replies

## Re: Total multiplied by rows in measure

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

12-07-2018 06:36 AM

Its is due to the scope of the filters.

Try creating a new measure with this check = hasonefilter(somecolumn) and add it to your table to find out which column has filter and not on the total value.

Then you can wrap your measure for ticket price into if(hasonefilter(filteredcolumn);do something; dosomething else)

see this video as well explaining why this is happening:

https://www.youtube.com/watch?v=Ka7Ds4EAjNQ

## Re: Total multiplied by rows in measure

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

12-07-2018 06:38 AM

Try the following using the values function.

In the values function you need to put the **DIMENSION** which is in the first column on the table.

It is not visible on your image

sumx( **VALUES**( 'Step6'[**DIMENSION**] ); CALCULATE(SUM( hour('Step6'[Times.Time])))) + do the same for the other 3 measures

## Re: Total multiplied by rows in measure

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

12-09-2018 11:46 PM

@solvisig thanks for that awesome explanation with a video.