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 am trying to compare one value in a column of rates vs the average of all of the rates in that same column. So far, I tried:
@Anonymous , to have these work is either use allexcept or have a separate table for carrier and then use all for that
Total Bids =
CALCULATE(
AVERAGE( 'Carrier Bid'[Linehaul Fuel] ),
ALL('Carrier'[Carrier]))
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |