flag with measure inside

[Ran]

hi,

i have 2 tables 

1 with budget

and 1 with invoices

now i want to do a flag in the dashboard that say if sum invoice > budget , 1 else 0

and show only the drivers and spent more then their budget

i tried to do master item with dimension but its not giving me 1 OR 0 

if i do it in measure its give me 1 OR 0 

but then i cant filter it in the table i show in dashboard

please help me if you know a solution or have any other idea

🙂

[mpc · Accepted solution]

Hi,

For better performance, you should try to create the flag in the data model.
Nevertheless, you can use Aggr function, like this:

Aggr(Sum(Exp1) = Sum(Exp2), Dim1, Dim2) with Dim1 and Dim2 dimensions in your chart.

Kind regards