The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I'm new to the forum and would appreciate some help.
I have Filters on all pages, that the end user can choose for either date range, and/or segment. I have created a RANKX measure, which uses those filters.
I want to see which individuals are costing the most in repair costs, by segment, for the date period chosen. (The DateKey is used as there are a few different date fields in the model). This is the DAX I've written to do that:
Solved! Go to Solution.
Try
Individual Ranked Total Repair Costs LY =
CALCULATE (
RANKX ( ALL ( 'Repair Data'[Individual Name] ), [Total Repair Costs],, DESC ),
ALLSELECTED ( 'Repair Data'[Segment] ),
ALLSELECTED ( 'Calendar' ),
SAMEPERIODLASTYEAR ( 'Calendar'[DateKey] )
)
What is the definition of [Total Repair Costs]? Is that manipulating the filter context ?
Thanks for responding!
Total Repair Costs is using a filter in it's DAX formula as I only want to include certain statuses of repairs. It's a measure that I want to display in a graph. So the graph will show the top ranked individuals in the X axis, with the costs showing as the size of the bar.
Total Repair Costs =
Try
Individual Ranked Total Repair Costs LY =
CALCULATE (
RANKX ( ALL ( 'Repair Data'[Individual Name] ), [Total Repair Costs],, DESC ),
ALLSELECTED ( 'Repair Data'[Segment] ),
ALLSELECTED ( 'Calendar' ),
SAMEPERIODLASTYEAR ( 'Calendar'[DateKey] )
)
That's great, thank you so much!
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |