I created a DAX formula to look up a value in my data set based on three parameters. I.e. Find and sum where data fields equal, 1, 2, 3, etc...
Here is the logic, Sum column "Financial" where:
  • Account[Account 2]="42.1-Outside Search Fees"
  • Segment[Segment Name]="Adjustments"
  • Adaptive_Mapping[Level 5]="COMMERCIAL SERVICES STG GROUP"

Here is the formula...
42.1 Adj Comm STG:=CALCULATE(SUM(Financials[Financials]),Account[Account 2]="42.1-Outside Search Fees", Segment[Segment Name]="Adjustments",Adaptive_Mapping[Level 5]="COMMERCIAL SERVICES STG GROUP")

Problem is when I bring it into PowerPivot, that number is repeated everywhere, not just at the intersection in the pivot.

Here is what I see below...
This is what it currently looks like Now…
capture1.jpg

This is what I want it to look like....
Capture2.JPG

What am I doing wrong???

Thanks!!!!