Output related data from Table

Hi Anonymous,

You can create line chart with these date and use MATERIAL as legend. Slicer with 'MATERIAL' column as source.
After these steps, you can use slicer to control display line amount.

Regards,

Xiaoxin Sheng

Hi,

I've tried getting help.  but still stucked..

I created a table as below and made relationships.

Below is the DAX that controls and outputs each of the material.

Total = IF

 (ISFILTERED(TOPO[REGION]),

    SWITCH(FIRSTNONBLANK(TOPO[StationID3], TOPO[REGION]),

            "LONG", [LONG],

            "SHORT", [SHORT],

            "MEDIUM",[MEDIUM],

                           BLANK()))

This is what I get when I select a  Material.

Below is what I am expecting to output

I want such that if I select LONG, it will output its related data . ie  : PAPI, LAND and CART on same graph.

This DAX works for a similar on Page 1 and Page 2 .

The problem is page 3

 Please help