Relationship problem

[Anonymous]

Hi all,

i hope someone has an idea, what's my problem - because currently I just don't know how to fix it.

I have product cluster as filters and i'd like to visualize data about the faqs shown on the different levels on our website and how they have been rated. (1 asset can have many ratings and 1 asset can belong to many clusters...)

And in the yellow frame i'd like to display a vote ratio.

But when I'm calculating the vote ratio on the fly via quick measure

Vote Ratio = DIVIDE(SUM('factRatings'[Count positive votes]),SUM('factRatings'[Count votes]),0)

my table reacts like this:

--> The Asset ID  (from factCluster) disappears...Seems like i'm running into a relationship problem...

And if i drag "asset_id" from another factTable than factCluster, the visual isn't responding to the 4 Cluster level filters in the section above anymore...

Thanks in advance!

[sergej_og]

you are welcome 🙂

[sergej_og · Accepted solution]

factCluster has distinct values for "asset id"?
You can try following approach:
 - deactivate relationship between dimAsset --> factCluster.
 - create relationship between factCluster --> factFaqRatings (I guess it will be m:n)

What happens after adjustments?

[Anonymous]

no, factCluster doesn't have distinct values for "asset_id".

Your approach was right, sergej_og!

The many-many fixed it 🙂

THANKS