Forum Discussion
Advocate IITop 15 in a report
I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.
Unreal, this worked =), thanks so much. Would you be able to explain why the calculate function was required? How is that different to just having SUM?
I have some weird behaviour as a result of this measure. It works perfectly, and I have a table in my report that shows:
- Job ID (unique identifier)
- Days overdue
- Rank (with 1 being the most overdue)
This all works fine, and my rank goes from 1 up to 15. However, when I add to the table the Case Description (a short text description), all of a sudden the Rank calculation reverts to all 1s again. Anyone able to explain why this would happen?
SeanCommunity Champion
What table is the Case Description field in? And how are the tables related?
It's all just in the same table. For some background, I have been using Excel to do reporting for years, and I'm now starting to look into putting everything into Power BI. So I'm very new to tables and things like that. I'm actually wondering if there's some basic online training I could do to help with my understanding.
- Sean
If its all in the same table that should definitely not happen???
Weird. So this is my table without the case description (everything working fine):
Without case description
And here it with the case description. All I've done to add this to the table is to drag it from the field list into the 'Values' section of the visualisation:
With case description
Thanks so much again for your help, this is really helping me understand how it all works. I think once I can work through a couple of examples I'll be able to teach myself a lot more effectively.
Stuart