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.
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
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |