How to tag a measure with a selected category?

[engyin2]

Hi, 

I have details transaction from SAP source but there is top level adjustment done outside SAP system hence the reported number is lower than the SAP total sum.

I have created the below measure to calculate the top level in BI. May I know how to tag the calculated amount with "Other Supplier" so that I can have the reported number by Supplier inc. the top level adj ?  Please help. Thanks.

[Floriankx]

Hello,

you could try and add an additional table to your BI:

Table: Top_N_Group

Group	ID
Total SAP	1
Other Supplier	2

Wraper Top N:=IF(ISFILTERED(Top_N_Group[Group]),
 SWITCH(MAX(Top_N_Group[ID]),
  1,[Total SAP],
  2,[Top Level],
Blank())

Then you create a Pivot with your Group as row your supplier as row below and [Wraper Top N] as value.

[engyin2]

Hi, 

I am trying to have the calculated measured to have vendor categorised as "Other Vendor" but not sure how to write the DAX formula to have it tag.

Below is the visual I would like to have in BI. Thanks.

[engyin2]

Hi anyone can help?