Forum Discussion
Create a Measure to Filter Column based on Another Column Value
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
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"
3 Replies
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"
works like magic, thank you Amik!
Hello
it could be like this:
Medida1 = CALCULATE( sum(Table[Value]), Table[Attribute] = "FC DBNR" )
