Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I'm starting at PowerBI.
I have a column with the sales codes and another with the code for my product.
I want to filter through the product code and have all sales codes that have this code listed in the table. But I also want the same table to show the product codes.
I do not know if I use stockings or just filter.
Solved! Go to Solution.
Hi, One Way is this:
Step 1: Add a New Table with Cod Prod
Modeling - New Table
CodProdTable = DISTINCT(Table1[Cod Prod])
Step 2
Add a measure
FilterM = COUNTROWS ( SUMMARIZE ( FILTER ( Table1; CALCULATE ( COUNT ( Table1[Cod Prod] ); FILTER ( ALLEXCEPT ( Table1; Table1[Sales Code] ); Table1[Cod Prod] = SELECTEDVALUE ( CodProdTable[Cod Prod] ) ) ) > 0 ); Table1[Sales Code] ) )
Step 3: And in Visual Level Filter Add this Measure To Is Not Blank
Another Way is Replacing Step 2 with.
FilterM = COUNTROWS ( INTERSECT ( CALCULATETABLE ( VALUES ( Table1[Cod Prod] ); ALLEXCEPT ( Table1; Table1[Sales Code] ) ); VALUES ( CodProdTable[Cod Prod] ) ) )
Regards
Victor
Hi @carlosarmpb,
Based on the image you are showing if you select on the slicer the code 1000 the table will be filter out for the products where prod_code is 1000.
What is your expected result and what are your particular requests.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYeah, that's fine.
But I want this table also to show all the product codes that have the same sales code.
Another Way is Replacing Step 2 with.
FilterM = COUNTROWS ( INTERSECT ( CALCULATETABLE ( VALUES ( Table1[Cod Prod] ); ALLEXCEPT ( Table1; Table1[Sales Code] ) ); VALUES ( CodProdTable[Cod Prod] ) ) )
Regards
Victor
Hi, One Way is this:
Step 1: Add a New Table with Cod Prod
Modeling - New Table
CodProdTable = DISTINCT(Table1[Cod Prod])
Step 2
Add a measure
FilterM = COUNTROWS ( SUMMARIZE ( FILTER ( Table1; CALCULATE ( COUNT ( Table1[Cod Prod] ); FILTER ( ALLEXCEPT ( Table1; Table1[Sales Code] ); Table1[Cod Prod] = SELECTEDVALUE ( CodProdTable[Cod Prod] ) ) ) > 0 ); Table1[Sales Code] ) )
Step 3: And in Visual Level Filter Add this Measure To Is Not Blank
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |