Forum Discussion

akbjf's avatar
akbjf
Helper I
6 years ago
Solved

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 th...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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"

DR_GT's avatar
DR_GT
New Member
6 years ago

Hello

it could be like this:

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