Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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!
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.
Proud to be a Super User!
HI @MR007
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
44 | |
16 | |
12 |