slicer selection result

[sanjanarama]

I have a dropdown slicer for activity column. if any activity is selected then results should be displayed based on column "Part one" column.

Threat	Node	Activity	Part One	Part Two	Part Three
Area One	Down	Name 1		Base Management
Area One	Down	Name 2	Base Management	Production Shop	Flow Assurance
Area One	Up	Name 3		Production Shop	Base Management
Area One	Up	Name 4		Production Shop	Process Engineer
Area One	Up	Name 5		Flow Assurance	Production Shop
Area One	Left	Name 6		Production Shop	Flow Assurance
Area One	Left	Name 7		Production Shop	Flow Assurance
Road	Right	Name 8		Base Management	Production Shop
Road	Right	Name 9	Base Management	Gateway	Flow Assurance
Upper Deck	Right	Name 10		Base Management	Production Shop
Upper Deck	Right	Name 11	Base Management	Production Chemist	Process Engineer

for example. 
if activity "Name 1" is selected , corresponding "part one" value is blank, the result should display as "no results"

if  activity "Name 2" is selected , corresponding "part one" value is "Base Management"/ any value in it, the result should display as table of its value

[Shishir22]

Hello @sanjanarama ,

As per my understanding from above post you are getting blank for Part One and you want to replace it with "No Results"

Use below calculated column in place of Part One.

Column = if(ISBLANK(Data[Part One]),"No Result",Data[Part One])

Please mark it as solution if it resolves your issue. Kudos are also appreciated.

Cheers,

Shishir

[sanjanarama]

@Shishir22 no, i have edited my requirements. please view that again and help me

[Shishir22 · Accepted solution]

Hello @sanjanarama ,

I dont think that will be acheivable directly.

Though you can try workaround-

Apply visual level filter on visual as Part One not equals to Blank.

Try to create a measure as below, add it into card visual and place it behind table visual keeping table visual backgournd as off.

Measure = if(HASONEVALUE(Data[Part One]) && min(Data[Part One])= BLANK(),"No Results as Part one is blank","")

Turn off the Category label to off and place this card visual behind table visual.

[sanjanarama]

thank you. it worked