The main issue in your current measure is how the filter context and SELECTEDVALUE interact when a single vendor (or multiple vendors) is selected in a table/matrix visual.
When you put [Vendor Name] on rows and this measure in values:
- SELECTEDVALUE ( 'Vendor Scorecard'[Category] ) usually returns BLANK (not the category), because the filter context has multiple rows from the same category → SELECTEDVALUE returns blank when >1 distinct value exists.
- When it is blank, your filter 'Vendor Scorecard'[Category] = SelectedCategory becomes [Category] = BLANK(), which matches nothing → you get the grand total average across all vendors/categories (that's why you see the same number everywhere).
Recommended Fix (Most Common & Clean Pattern)
Remove SELECTEDVALUE and let the existing row context from the visual (or slicer) set the category automatically.
You only need to remove the vendor filter — keep the category filter coming from the visual.
dax
%_VendorScore_Avg_Category =
VAR brand = 0.14
VAR eob = 0.13
VAR finance = 0.17
VAR service = 0.18
VAR supplychain = 0.14
VAR technology = 0.09
VAR opportunity = 0.15
RETURN
CALCULATE (
([#_BrandScore_Avg] * brand)
+ ([#_EaseofBusiness_Avg] * eob)
+ ([#_Finance_Avg] * finance)
+ ([#_Service_Avg] * service)
+ ([#_SupplyChain_Avg] * supplychain)
+ ([#_Technology_Avg] * technology)
+ ([#_Opportunity_Avg] * opportunity),
REMOVEFILTERS ( 'Vendor Scorecard'[Vendor Name] )
-- optionally: REMOVEFILTERS ( 'Vendor Scorecard'[Vendor Name], other columns you want to ignore )
)
Why this usually works best
- When the visual has [Category] on rows (or in a slicer) → category filter stays → you get correct per-category weighted avg
- When the visual has [Vendor Name] on rows → vendor filter is removed → calculation happens over all vendors in the same category as the current vendor row (because category filter from the data model / relationship / page / slicer remains)
- When nothing filters category → you get the overall weighted average (grand total)
Alternative (Explicit — if the simple version doesn't work)
If you have a complex filter setup and the category context is being lost, you can capture the vendor's category first:
dax
%_VendorScore_Avg_Category =
VAR brand = 0.14
VAR eob = 0.13
VAR finance = 0.17
VAR service = 0.18
VAR supplychain = 0.14
VAR technology = 0.09
VAR opportunity = 0.15
VAR CurrentVendorCategory =
CALCULATE(
SELECTEDVALUE ( 'Vendor Scorecard'[Category] ),
REMOVEFILTERS ( 'Vendor Scorecard'[Vendor Name] ) // optional — usually not needed here
)
RETURN
IF(
ISBLANK ( CurrentVendorCategory ),
BLANK(), // or return grand total if preferred
CALCULATE (
([#_BrandScore_Avg] * brand)
+ ([#_EaseofBusiness_Avg] * eob)
+ ([#_Finance_Avg] * finance)
+ ([#_Service_Avg] * service)
+ ([#_SupplyChain_Avg] * supplychain)
+ ([#_Technology_Avg] * technology)
+ ([#_Opportunity_Avg] * opportunity),
REMOVEFILTERS ( 'Vendor Scorecard'[Vendor Name] ),
'Vendor Scorecard'[Category] = CurrentVendorCategory
)
)
But in 90% of typical vendor/category scorecard reports, the first (simpler) version is enough and cleaner.
Quick Test Sequence
- Try the first (simpler) version — just remove the SELECTEDVALUE part and the category filter.
- Put [Vendor Name] on rows + this measure → each vendor should now show its category's average.
- If still wrong → check whether [Category] is on the visual, in a slicer, or coming from a relationship — and share more about your visual setup.
