Forum Discussion
var/return
Hi Anonymous ,
I am not sure your data structure, you could refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
what is the question?
I am trying to use the rankx function
when i try
RANKX( ALL(Table[column1]),
CALCULATE(SUMX(Table, Table[column2]),FILTER(Table,Table[month]))it gives the contant ranking of 1
except i use 2 different measuresMeasure2 = RANKX(ALL( table[column1]), Measure1)
measure1= CALCULATE(SUMX(Table ,Table[Column2),FILTER(Table,Table[month]))so
i was wonering if its is possible to infuse- amitchandak
Super User
Can you share sample data and sample output.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 
daxCommunity Support
Hi Anonymous ,
I am not sure your data structure, you could refer to my sample for details. If this is not what you want, please correct me and inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Anonymous , Hope above solution has worked for you
