Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 3 tables as belows. I wanna create slicer of customer, in which. when I choose 1 specific customer (Ex: Customer A) => It will show the the visual as "result1".
If I don't choose that slicer, it will show the visual as " result2"
So, what Dax formulas can I use ?
Thanks in advance for your support!
I
Solved! Go to Solution.
Hi Ngocnguyen,
This might be worth a try:
Measures:
Proud to be a Super User!
Hi @ngocnguyen
I prepared a solution for you.
You can create this 4 measures:
Selected Customer =
IF(ISFILTERED(Table1[Customer]), CONCATENATEX(DISTINCT(Table1[Customer]), Table1[Customer],","),
"ALL Customers")
Actual =
Sum(Table1[Actual Amount])
Target =
IF(ISFILTERED(Table1[Customer]),
Sum(Table2[Target]),
MAX(Table3[Target])
)
Compare = [Actual] - [Target]
Proud to be a Super User. If I helped, please accept the solution and give kudos! |
Hi @ngocnguyen
I prepared a solution for you.
You can create this 4 measures:
Selected Customer =
IF(ISFILTERED(Table1[Customer]), CONCATENATEX(DISTINCT(Table1[Customer]), Table1[Customer],","),
"ALL Customers")
Actual =
Sum(Table1[Actual Amount])
Target =
IF(ISFILTERED(Table1[Customer]),
Sum(Table2[Target]),
MAX(Table3[Target])
)
Compare = [Actual] - [Target]
Proud to be a Super User. If I helped, please accept the solution and give kudos! |
Hi Ngocnguyen,
This might be worth a try:
Measures:
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |