Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We are trying to solve a problem which involves following steps.
Step 1: First product slicer selection which will filter the table visual for sales related to chosen product.
Step 2: Second step need to fulfill following operations
Below is the sample model
Thanks.
Solved! Go to Solution.
Hi @RVK ,
Below is my table:
The following DAX might work for you:
Measure =
VAR cor = SELECTEDVALUE('Product'[Product ID])
var name1 = SELECTEDVALUE('Customer'[Customer Name])
var CID = SELECTEDVALUE(Sales[CustomerID])
var result1 =
not(
CALCULATE(
SUM(Sales[Sales]),
FILTER(Sales , Sales[ProductID] = cor)
)
)
RETURN
IF(result1 = true ,cor,BLANK())
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RVK ,
Below is my table:
The following DAX might work for you:
Measure =
VAR cor = SELECTEDVALUE('Product'[Product ID])
var name1 = SELECTEDVALUE('Customer'[Customer Name])
var CID = SELECTEDVALUE(Sales[CustomerID])
var result1 =
not(
CALCULATE(
SUM(Sales[Sales]),
FILTER(Sales , Sales[ProductID] = cor)
)
)
RETURN
IF(result1 = true ,cor,BLANK())
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |