Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Advocate IV
1 year ago
Solved

Narrative Measure Not Matching Correctly

Hi all, I have this table of values: You'll see that the highlighted value of 20 for the Function 'Executive Assistants' is the highest value in the table.  I'm using the following metric to ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, garynorcrossmmc 

     

    You can try the following methods.

    Measure = MAXX(ALL('Table'),[Employees - Receiving Special Bonus])

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi garynorcrossmmc - First, check that the granularity of the data is consistent with how you are trying to calculate the top value. If there are duplicates or variations in other columns, the TOPN may behave unexpectedly.

Modified measure:

 

Colleagues (Receiving Special Bonus) - Top Function # (TOPN) =
VAR TopFunction =
TOPN (
1,
SUMMARIZE(
'OWG Comp Listing',
'OWG Comp Listing'[Function],
"TotalEmployees", [Employees - Receiving Special Bonus]
),
[TotalEmployees],
DESC
)
RETURN
CALCULATE(
[Employees - Receiving Special Bonus],
FILTER(
'OWG Comp Listing',
'OWG Comp Listing'[Function] IN TopFunction &&
'OWG Comp Listing'[Year] = 2024
)
) + 0

 

 

Hope this helps.

  • garynorcrossmmc's avatar
    garynorcrossmmc
    Advocate IV
    1 year ago

    Thanks for the reply, rajendraongole1!  I'm receiving this error from the calc, do you have any recommendation on how to get around this?

    The number of arguments is invalid. Function CONTAINSROW must have a value for each column in the table expression.