word cloud doesn't seem to filter on the right data in a table

[tonygill1225]

I am using a field called Tags where I see words show up just right in word cloud chart but in the bigger table, if I pull tags to confirm on the data when one of the words from word cloud chart is selected, it's showing incorrect rows filtered. Am I missing a relationship somewhere? I'm pulling from the same source and I'm filtering on the exact same filters (on both table and word cloud chart). Any info here would be super helpful as I think this chart works for my case well.

[v-sihou-msft]

@tonygill1225

In this scenario, how did you create your "Tag" field. I re-model the source table and create a measure which returns correct results.

I have a table like:

1. Unpivot the column.

2.  Split the column by space.

3. Unpivot columns again.

4. The final result will be like:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s1MLsovzk8rUYrVQeIpBOSXpxYpOHmChVE4wYE+SrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Words = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Words", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Columns","Value",Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv),{"Value.1", "Value.2", "Value.3"}),
    #"Unpivoted Columns1" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {"Attribute"}, "Attribute.1", "Value")
in
    #"Unpivoted Columns1"

Then create a measure to calculate the occurance of each word:

Occurence = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Value]))

Regards,