Creating a measure which returns the sum only when a specific value is selected in the slicer

Question

Hey Everyone,&nbsp;Hope you're well. I am trying to create a measure which returns the sum of "count" only when I select a specifc value in the slicer.For example:I am trying to create a measure which will return the sum of "count" column only when Apple is selected. If any other value is selected it should return 0. Any help is appreciated.&nbsp;Thanks!&nbsp;

greg_deckler · Accepted Answer

akkitek&nbsp;Measure = IF(SELECTEDVALUE('Slicer'[Fruits])="Apple",SUM('Table'[Count]),0)

Forum Discussion

Creating a measure which returns the sum only when a specific value is selected in the slicer

2 Replies

Related content

Fabric Notebook ExitValue how to select specific values

Specific matrix

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Creating ICMs via Activator

Create new table by selecting specific columns and filter.