Unable to check if the current row column value is selected as a slicer from another table

[Anonymous]

Hi All,

I am building a custom report where rows are populated from a Report Table.  Based on the value of the 1st column in the report and based on the fact  if the same value from a Reference Table has been selected , show a measure.

The Slicer is from the Reference Table, 

The middle one is the Report Layout from Report Table.

The last one is the final desired one.

The measure 10 USerEntry  is like this

10 UserEntry = 
var Index = SELECTEDVALUE('Report Table'[Index])
Return
      SWITCH (Index,"510-01",SelectedVALUE(Parameter[Parameter]),
             "510-02",SelectedVALUE('CoLOS Base?'[CoLOS Base?]),
             "510-03",SelectedVALUE('LineFactory?'[Line / Factory ?]),
             "510-04", IF (ISFILTERED('Reference Table'[Questions]),"Yes","-" )
             
             )

What I am trying to do is get the Index field value of row in the report layout, based on the value get appropriate values from other tables / slicers. The first 3 entries no problems.  The fourth one "510-04" is showing "-".

From 4th one till 15th row of the report we need to check if the Question from Report Table has been selected in the slicer of Reference Table, if so show Yes. other wise "-".

The two tables Report Table and Reference Table are same but not linked.

The data file link

DataFile 

@OwenAuger   any suggestions.

Cheers

CheenuSing

[Anonymous]

Hi All,

I resolved the issue and am able to get the measures I want.

Here is the sample screen .

The application will work only for SCODE = S27510.

Check this with CoLOS Base? always as No.  If you choose Yes, it will be limited to 3 rows.

The measures displayed as columns are computed and is available as Measure table in the attached link to PBIX.

You will notice the final table visual is a custom report, with different values of each  measure  displayed depending on the Question in the row.

I am unable to get the Total for the measure column 13 Component Value.

Any help to acheive this will be greatly appreciated.

PBIX USED 

@OwenAuger , @MattAllington ,   @Zubair_Muhammad , @ImkeF    look forward to your help.

Cheers

CheenuSing

[Anonymous · Accepted solution]

Hi All,

Looks like if I post my problem to the comunity I get new ideas to resolve.  Some sort of telepathy working.

I have resolved the total column issue also, by using  a new measure

31 Component Value = SUMX (  ALL( 'Report Table'[Questions]), [13 Component Value] )

Cheers

CheenuSing