Create a Measure to Filter Column based on Another Column Value

[akbjf]

Hi all,

Hope you guys are doing good. I have a table like this:

Now, I want to have a measure that return all the value from "Value" column where the attribute is "FC DBNR".

None of the column is measure/calculated column.

Can you suggest me how to do it?

Thank you! Stay safe!

Akbar

[DR_GT]

Hello

it could be like this:

Medida1 = CALCULATE( sum(Table[Value]), Table[Attribute] = "FC DBNR" )

[amitchandak · Accepted solution]

@akbjf , Create this measure and use it with date or date and attribute in a visual

New Measure = calculate(sum(Table[Value]),Table[attribute] ="FC DBNR")

You can also us sum(Table[Value]) with visual level filter or slicer filtered on Table[attribute] ="FC DBNR"

[akbjf]

works like magic, thank you Amik!