Stuck with rolling up a measure! Help!

Anonymous — Fri, 12 Jul 2019 14:47:46 GMT

Calling all PBI Wizards,

I have been spinning my wheels on this for more time than I would like to admit and cannot come up with a solution. I have created a measure that is fairly straight forward and works in a table visual when it has the proper context:

Test = 

Var
    Max Date = 'Data'[Max Date]

var 
    Flag = if('Data'[Return] < 0, 1,0)
Return

Flag * calculate(sum('Data'[USD]), 
        FILTER('Data',
        sum('Data'[YR1_Return]) <> blank() &&
        'Data'[Flag] = "N" && 
        'Data'[Date] = Max Date))

The reason why this works in a table visual is it executing the multiplier in the context of an account, however when I remove the context of the account instead of multiplying each row by a 1 that meets the criteria, it multiplies my total amount by a 0 as there is not context for the flag variable, returning zero.

I have tried a calculated column in order to execute the flag on a row level, however this does not give me the same result, however I am not sure why.

My question is, how can I create a measure to roll this up as I need to use the results of this measure to generate multiple other measures.

Appreciate any and all help!

Thanks,

JMWB

Re: Stuck with rolling up a measure! Help!

Anonymous — Sat, 13 Jul 2019 16:17:38 GMT

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best

Darek

Re: Stuck with rolling up a measure! Help!

Anonymous — Sat, 13 Jul 2019 16:21:39 GMT

Hi again.

I wanna see your model (I already see that it's most likely incorrect) and would also want you to describe what the measure you're after should do.

Thanks.

Best

Darek

topic Stuck with rolling up a measure! Help! in DAX Commands and Tips

Stuck with rolling up a measure! Help!

Re: Stuck with rolling up a measure! Help!

Re: Stuck with rolling up a measure! Help!