Forum Discussion
ericOnline
Post Patron
6 years agoMEASURE: Sum/Avg with Condition Question
Hello, I'm trying to create a measure that calculates the rank in one table based on conditions in another table. Example: Here are the tables and relationship: The measure I have now to c...
v-lili6-msft
Community Support
6 years agohi ericOnline
When you click a record in the Rollup table (Table visual), it will filter other fields in the table visual too, not just Job Title field, so you'd better use a slicer instead it.
And if possible, could you please share your sample pbix file and your expected output? that will be a great help.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin