How to do it...

To implement this recipe, perform the following steps:

  1. Create the following measures:
Selected Color = 
    SELECTEDVALUE(
        'R02_Table'[Color],
        "Select a single value"
    )

Lookup Value = 
    LOOKUPVALUE(
        'R02_Table'[Value],
        'R02_Table'[Color],
        [Selected Color],
        "Select a single value"
    )

Divided = 
    DIVIDE(
        SUMX(ALL('R02_Table'[Value]),[Value]),
        SUM('R02_Table'[Value]),
        -1
    )

Find = 
    VAR __Text = CONCATENATEX(DISTINCT('R02_Table'[Color]),[Color])
RETURN
    FIND("u",__Text,,-1)

Search = 
    VAR __Text = CONCATENATEX(DISTINCT('R02_Table'[Color]),[Color])
RETURN
    SEARCH("u",__Text,,-1)
  1. On a Report page, create a Slicer visualization and place the Color column from R02_Table in the Field area of the visualization.
  2. On the same Report page, create a Card visualization and place the Selected Color measure in the Fields area of the visualization.
  3. On the same Report page, create a second Card visualization and place the Lookup Value measure in the Fields area of the visualization.
  4. On the same Report page, create a third Card visualization and place the Divided measure in the Fields area of the visualization.
  5. On the same Report page, create a fourth Card visualization and place the Find measure in the Fields area of the visualization.
  6. On the same Report page, create a fifth Card visualization and place the Search measure in the Fields area of the visualization.

Note that if nothing is selected in the slicer, the card visualizations for Selected Color and Lookup Value both display Select a single value. If only the color Red is selected in the slicer, then the Card visualizations for Divided, Find, and Search all display -1.