conditional formatting with hiding data display of a table

[sanjanarama]

I have a table and a filter, only after selecting a filter i wanted to show data in a table for which i used below measure 

DisplayTable = CALCULATE(IF( ISFILTERED(Table1[Part Three]) ,1,0), ALLSELECTED (Table1 ) )

Also along with that i wanted to change font based on value of another column, dax is 
Measure 6 = if(MAX(Table1[Part One]) = "Base Management",1,0)

after adding this conditional formating my table is showing all the data, i.e DisplayTable dax to show data based on filters is not working. any idea?

[sturlaws · Accepted solution]

Hi,

the measure [DisplayTable] did not make much sense. I have retwritten it in this sample report I created based on the information you provided. I also had to create second table with the Part 3 :
sample report 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[sanjanarama]

@sturlaws 

thank you, but what if there are multiple slicers in the report without any one selecting results should not display. for example now only part 1 column slicer is available, next i need both part 1 and part 2. 


I modified your measure, but this is not working 

DisplayTable = IF( ISFILTERED('dimPart3'[part3]) || ISFILTERED('Table'[part1]) ,1,0)

[sturlaws]

You need to create DimPart1, similar to DimPart3, and add DimPart[Part1] to the slicer