I was trying to create a DAX formula to show only the value of a particular line, however that number repeats all the way down. See image attached below.
I have a calculate formula and have defined the parameters, but that number get repeated everywhere... I only want it to appear once in the right spot, and everywhere else in that column "BLANK".
See Attached Image below for more detail.
Here is the current formula.
CALCULATE(SUM(Financials[Financials]),Account[Account 2]="42.1-Outside Search Fees",Adaptive_Mapping[Level 5]="COMMERCIAL SERVICES STG GROUP",Segment[Segment Name]="Adjustments")
What am I doing wrong, and why is it repeating versus only showing up one and all other rows show "BLANK"
I have a calculate formula and have defined the parameters, but that number get repeated everywhere... I only want it to appear once in the right spot, and everywhere else in that column "BLANK".
See Attached Image below for more detail.
Here is the current formula.
CALCULATE(SUM(Financials[Financials]),Account[Account 2]="42.1-Outside Search Fees",Adaptive_Mapping[Level 5]="COMMERCIAL SERVICES STG GROUP",Segment[Segment Name]="Adjustments")
What am I doing wrong, and why is it repeating versus only showing up one and all other rows show "BLANK"
