Changing data set for a visual based on slicer

[harshadrokade]

I have mentojned below a sample dummy data. I have these two seperate tables

Year	Segment	Locality	Locality score
2010	PQR	USA	A
2011	XYZ	UK	D
2012	ABC	China	C

Year	Segment	Segment score
2010	PQR	B
2011	XYZ	D
2012	ABC	C

I have three slicers as Year, Segment & Locality. I have a card visual as 'Score'. 

This visual should have Locality score if specific Locality is selected in Locality slicer however if 'All' is selected in Locality slicer, the same visual should show Segment score as there is no specific Locality selected & now we want Segment level data. 

Example- 

If Segment slicer has value as PQR selected & Locality slicer has value selected as USA- Card visual will show value as 'A' which is of Locality as USA

If Segment slicer has value as PQR selected & Locality slicer has value selected as All- Same Card visual will show value as 'B' which is of Segment as PQR

Pls help.

[v-xiaotang · Accepted solution]

Hi @harshadrokade 

Try this.

Create the measure:

Measure =
  var _Seg= SELECTEDVALUE(SegSlicer[Segment])
  var _SegScore= CALCULATE(SELECTEDVALUE(Table2[Segment score]),Table2[Segment]=_Seg)
  var _Loc= SELECTEDVALUE(LocSlicer[Locality])
  var _LocScore= CALCULATE(SELECTEDVALUE(Table1[Locality score]),Table1[Locality]=_Loc)
return
  IF(ISBLANK(_Loc),_SegScore,_LocScore)

Result:

See sample file attached below.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[harshadrokade]

Thanks a lot for all your help sir. Very much appreciate your help