Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a slicer where you can select products - A, B, C, D, E.
Let's say you select products A, B and you get a matrix/table with list of customers and the total sales made to them (non-zero values only). Let's say this is visual 1.
Once I get this matrix/table with customer list, I want another table/matrix which shows me the total sales made to the same customers in visual 1 but with the remaining products not selected in the slicer i.e. for C, D, E.
How can I approach this?
Solved! Go to Solution.
Hi @afaro ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a new table
Table 2 = VALUES('Table'[Prouct])
Create measres
Sales amount by Product =
CALCULATE(
SUM('Table'[Sales]),
ALLEXCEPT(
'Table',
'Table'[Prouct]
)
)
Measure 1 =
IF(
SELECTEDVALUE('Table'[Prouct]) IN VALUES('Table 2'[Prouct]) && [Sales amount by Product] <> 0,
1,
0
)
Measure 2 =
IF(
SELECTEDVALUE('Table'[Prouct]) IN VALUES('Table 2'[Prouct]),
1,
IF(
[Sales amount by Product] = 0,
1,
0
)
)
Appply measure 1 to visual 1 and measure 2 to visaul 2
Fianl output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @afaro ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a new table
Table 2 = VALUES('Table'[Prouct])
Create measres
Sales amount by Product =
CALCULATE(
SUM('Table'[Sales]),
ALLEXCEPT(
'Table',
'Table'[Prouct]
)
)
Measure 1 =
IF(
SELECTEDVALUE('Table'[Prouct]) IN VALUES('Table 2'[Prouct]) && [Sales amount by Product] <> 0,
1,
0
)
Measure 2 =
IF(
SELECTEDVALUE('Table'[Prouct]) IN VALUES('Table 2'[Prouct]),
1,
IF(
[Sales amount by Product] = 0,
1,
0
)
)
Appply measure 1 to visual 1 and measure 2 to visaul 2
Fianl output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @afaro
It depends. How many products do you have in your real data? Can you provide a small dammy sample to work with?
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
40 | |
28 | |
22 |