measure to calculate value and filter

[topazz11]

Hi Guys, 

I have created a measure to calculate "base - hour" but it didn't work.

base value still shows sum of it not the real value.

also it is totally changee when i filter out 0 value from the table.

Can anyone advise please?

pbix is here

pbix 

pbix 

desired output is like this

[Wilson_ · Accepted solution]

Hi topazz11,

I cannot access your pbix link. I think you need to check your sharing permissions.

[Wilson_ · Accepted solution]

topazz11,

Here's my updated copy of your pbix, with your data model untouched. Keep in mind the base measure will only work as intended if the visual you use it in only has the columns shown in the SUMMARIZE function. (I think ideally your data model would look a little different, but that's another story for a different day. :D)

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Wilson_]

@Ashish_Mathur,

Average was my first thought but it doesn't work because the totals are incorrect.

[Wilson_ · Accepted solution]

Hi topazz11,

I cannot access your pbix link. I think you need to check your sharing permissions.

[topazz11]

The link should work now.

[Wilson_ · Accepted solution]

topazz11,

Here's my updated copy of your pbix, with your data model untouched. Keep in mind the base measure will only work as intended if the visual you use it in only has the columns shown in the SUMMARIZE function. (I think ideally your data model would look a little different, but that's another story for a different day. :D)

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

[topazz11]

thank you! I couldn't think about summarizing the table. good to know!