Forum Discussion

thliberato's avatar
thliberato
Icon for Helper I rankHelper I
9 years ago

Value selected in the filter

 How do I get a value selected in the filter to use in a measure ?   For Example. I create a filter with myoptions. I created a measure named Test (I know that this sintax is wrong). Test = ...
Need Help
Show and Tell
JaimeG's avatar
JaimeG
New Member
9 years ago

you can try this

 

Measure = CALCULATE(SUM(Table[Fieldvalue]);FILTER(Table;Table[FieldOption]="Option 1"))

you can use SUM, COUNT, and any agregate function