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.
I apologize if this isn't the best format or area to post, I just registered for the community a few minutes ago.
**The highlighted measure total is what I don't want 'added' up. I want the average ratio to be displayed. How to make that happen?
Solved! Go to Solution.
A measure seems like the better option to me.
Try this as a measure:
2017 Ratio =
DIVIDE ( SUM ( Table1[FV Total] ), SUM ( Table1[SalePrice] ) )
Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao
To clarify, the 2017 ratio(top left visual) is a calculated column. Dax = taking the sales price / FV total = ratio. This calculated column is what is displayed in the visual but I don't want the total 'sum' at bottom, I want the average.
1. should i keep as calculated column and create new measure or,
2. create measure to get my ratio's and then displaying them should be cleared up?
again, sorry about the format of this question, brand new to power bi and the community.
A measure seems like the better option to me.
Try this as a measure:
2017 Ratio =
DIVIDE ( SUM ( Table1[FV Total] ), SUM ( Table1[SalePrice] ) )
I will give it a shot. Thanks for the input. Let you know in morning.
You have to create measures. Once you have a measure that works on the individual PID level, say its name is [PID Level Measure] (should be hidden), then you create this general measure:
[Ratio] =
averagex(
distinct( T[PID] ),
[PID Level Measure]
)
Sorry for stupid question to follow here... Whats the difference?
The original measure, created on the PID level, is
You are changing the aggregation for the [FV Total] measure, not the [2017 ratio] measure you have highlighted in your visual. Try using the dropdown for [2017 ratio] in the pane on the right instead of the dropdown for [FV Total].