Forum Discussion

OBMBI's avatar
OBMBI
Frequent Visitor
5 years ago

Filter based on a related column with RANKX

I am trying to calculate the TopN value for Confidence by Provider name for the latest date.   The below works for the ProviderId but the Provider Name is available in a separate table. These are r...
DAX
RANKX
TopN
amitchandak's avatar
amitchandak
Super User
5 years ago

OBMBI , if you create a rank on provider id and use it with provider name in visual, this means rank of provider id insider provider name

 

You need to include provide name in Rank

OBMBI's avatar
OBMBI
Frequent Visitor
5 years ago

Hi amitchandak,

Thanks for the reply, I am using the ProviderId in the RANKX and when I use the Provider Name in the visual, all ranks get set to 1.

 

Also, how would you include the Provider Name in the RANKX function? The ALLSELECTED only accepts fields from the same table, but they are in separate tables.