How to identify spend on specific doc type with other doc type as well

[Anonymous]

Hi Team,

i need solution on below logic, 

here i want to show only those vendors whoes spend happened with Doc type "OP" & with other Doc type too..e.g: (doc type = "OP" || doc type = "others")

if spend is happening with Only Doc type "OP" and with only other Doc type not required...e.g: ((doc type = "OP") and (doc type <> "OP" || doc type = "others"))

please find attached sample data for your reference i want only "Xyz" & "Lmn" vendor rows...

Thanks in advance..

Vendor Name	Document Type
OP	XE	XR	XN	XM
Abc					$ 300.0
Xyz	$   90.0	$ 200.0		$ 230.0
Lmn	$ 150.0		$ 125.0
Efg	$   85.0

[Anonymous]

Hello,

Thanks for prompt replay,

i have data as attached visual metrix table (row headers: vendor name, col: doc type , value: amount)

can you please help me with how to do changes in this visual using your solution.

Thanks!

[ValtteriN]

Hi,

After you have created the calculated table like Vahid suggested. You can place values from this new table to your matrix and the values shown should fit your end goal. So in short use the new table to create the matrix.

[VahidDM]

HI @Anonymous 

If your data table is like:

then use this code to add a new table with DAX:

New Table = 
FILTER (
    'Table',
    NOT ( ISBLANK ( 'Table'[OP] ) )
        && ( 'Table'[XE] + 'Table'[XR] + 'Table'[XN] + 'Table'[XM] ) > 0
)

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]