Hi there,
I',m trying to write a measure that ensures ALL values in both the 'Release Success Data'[Combined Distinct Clients] and 'Incidents'[Client] columns are used as the pretext for ranking measures that calculate rankings in each dataset.
Ideally I'd like to be able to consolidate both values into one visual but can't quite get the DAX to work. I have an indirect (Many-Many - no option with that here) relationship betwen 'Release Success Data' and 'Incidents' on the 2 client columns however don't quite know how to adjust that into my RANKX measures for Release Success.
what I have for
"Incident Volume"
Incident Volume Rank =
RANKX(ALL('Incidents'[Client]), [Incidents per client], ,DESC)
What I currently have for Release Success ranking among clients:
Rank Succcess =
RANKX(ALL('Release Success Data'[Combined Distinct Clients]), [R.Success Rate] ,,ASC)
What I need is some kind of activitation in the Rank Succcess measure to activate the relationship to make PowerBI understand I want to really use ALL('Incidents'[Client]) at the start of that measure rather than referring to another column.
I am unable to use a bridge table as I have the Dates column connecting the 2 tables in the way to prevent us to be able to consolidate the clients into one - even in that scenario I need to activate the indirect relationships anyways so need to know how to figure that in my DAX.
Give me a shout if you have more questions
