Output related data from Table

[Anonymous]

Hi,

Please Help.

I created a table as below and made relationships.

MAKE	MATERIAL
PAPI	LONG
LAND	LONG
CART	LONG
PAPI	SHORT
LAND	SHORT
CART	SHORT
PAPI	MEDIUM
LAND	MEDIUM
CART	MEDIUM

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.

Thanks for your help

[Anonymous]

Hi,

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

I created a table as below and made relationships.

MAKE	MATERIAL
PAPI	LONG
LAND	LONG
CART	LONG
PAPI	SHORT
LAND	SHORT
CART	SHORT
PAPI	MEDIUM
LAND	MEDIUM
CART	MEDIUM

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

[Anonymous]

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

[Anonymous]

Many thanks for your help.

Moreover, I have tried your workaround and suggestion but still do not get the desired three lines   to appear on selection of the legend. 

[Anonymous]

Hi @Anonymous,

I'm not so clarify for your scenario, can you please share us sample pbix file for test?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin Sheng,

I've shared the Pbix to your email.

Many Thanks

Ichebbo

[Anonymous]

HI @Anonymous,

Based on test, your measure 'TotalTemperature' not works, when chosen multiple item, it only calculate with firstnonblank value, "Block A Heat.

In addition, I also check your relationship, it seems like you use 'single' mode of cross filter direction to link each tables.

For single relationship, filter effect only works on one side.

Regards,

XIaoxin Sheng

[Anonymous]

Hi XIaoxin Sheng,

I've done cross filter on both in the relationship but  Still dont get the desired result.

Please Can you help with an appropriate DAX that will not use firstnonblank.??

Is there a better way to create the STATIONID3s table? 

I've been in a fix and have not been able to move forward.

Thanks

Ichebobo

[Anonymous]

Hi,

I've done cross filter on both in the relationship but  no way forward.

Please Can you help with an appropriate DAX or workaroubnd that will not use firstnonblank.??

Many Thanks

[Anonymous]

Hi @Anonymous,

I'd like to suggest you use 'in' keyword with allselected/values functions to deal with multiple selection scenario.

Reference link:

From SQL to DAX: IN and EXISTS

BTW, I also have no idea how to deal with your relationship, when I try to change filter mode, power bi return errors.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin Sheng,

Thanks for your time.

I’ve updated the PBix to display all the expected visuals.

Page 1 and Page 2 are OK.

The problem is page 3 ie the STATIONID3  has smilar DAX expression as STATIONID, STATIONID2"  but do not display data.

Also I tried using another DAX expression for STATIONID3:

****************************************

IF (ISCROSSFILTERED
SWITCH(TRUE(),
VALUES
VALUES
VALUES
BLANK()))

 ************************************************still no success

I am still learning how to use IN and EXIST.

I've sent the updated PBix file to your email. 

Please help.

Many Thanks

Ichebobo

[Anonymous]

Hi,

Please Can you help with an appropriate DAX or workaround.??

I used a DAX expression for page1, Page2 and Page3 visuals 

Page 1 and Page 2 are OK.

The problem is page 3 as it does not display data.

Many Thanks