Forum Discussion
badger123
Resolver I
Resolver ITables and slicers
Hello folks, I have been thinking about how to slice my data for a number of different charts and have come up stuck on how to include and exclude data my report. phrase tags french wi...
Hi badger123 ,
We can use the following method:
First we can create two calculated table using the following DAX query:
tags = VALUES(Table1[tags])
phrase = SUMMARIZE(Table1,Table1[phrase],"tag",CONCATENATEX(Table1,Table1[tags],","))Then we can create a measure like below:
Measure = var a = CONCATENATEX(ALLSELECTED(tags[tags]),tags[tags],",") return IF(MIN(phrase[tag]) = a,1,0)
After that we can add this measure as filter:
The result will like below:
Best Regards,
Teige
badger123 you can do it in below way..Create a slicer for Tags and then create a bar graph as below:
badger123Hi Anonymous , thanks for the quick response. I misexplained what I was trying to achieve in my original post (it was completely contradictary - sorry). I have now amended the problem. Please let me know if you have any ideas!? :)