Forum Discussion
RANKX formula help
Hi eveyone!
Problem is , that I cannot figure out how keep and rank only these brands, which only has value in GRP column. At the moment it considers all the brands (I know, that I have ALL function in my code).
Code:
How the table looks with GRP rank measure at the moment
Sample data and PBIX: https://we.tl/t-6fUewOOSRb
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Sample data and PBix is here:
https://we.tl/t-6fUewOOSRbYou need to filter by GRP, something like this:
VAR _rank = RANKX(FILTER(ALLSELECTED('FINAL data'[Main brands]),[Total GRP]>0),[Viimase aasta GRP], , ASC, DENSE )You seem to have a few too many measures, and a lot of measure tables. Please don't uses ADDCOLUMNS(), , use something like
TV mõõdikud = {1}
