Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RankX with Filter

Hi, I was trying to build a RankX Forumla. My Condtions are a Fact Table (Value,Date,ID,Company) and a Date Table (Date). The Goal was a Ranking for the IDs for each company for each year for the ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I was trying to made it like that

but i get a ring addiction...(i dropped out the max, but get the same message with max in formula)

 

 

 

=RANKX(
	FILTER(
		ALLSELECTED(_data_vo);
			[company]=[company]&&[company_id]=[company_id]&&YEAR([Datum])=YEAR([Datum]));
		CALCULATE(
			SUMX(_data_vo;[Wert]));
	0;ASC;Dense)

 

 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.