Forum Discussion
Create Virtual Flag in Data with DAX Measure
This is something that is super easy to do with a calculated column, but I'm not sure how to implement the measure version in a live connection. I can pull data into a table visual from the serv...
flag_measures =
IF(
CALCULATE(
COUNTROWS(data),
ALLEXCEPT(data, data[Order Number]),
data[Product Name] = "ABC"
) > 0,
1,
0
)
Now, can filter out the flag which 0.
Now, can filter out the flag which 0.
I don't think this really works like I want it to. When looking at an order it returns every possible product, so if looking at order 456 for example it would show ABC, DEF, GHI, JKL, etc. and then when I bring in the Revenue metric it's just blank for all of the products anyways. It was also pretty slow.