Forum Discussion
Card visual showing one value coming from a specific data cell (Row-column).
Super UserLuigiRobert , for that either you have to use filters in measure of the slicer has to filter the value or visual level filters
calculate(Sum(Table[Value]), filter(Table,Table[ID] =200 && Table[cat] ="A") )
Hi Amitchandak,
thank you for answer, Im sorry, Im not a PBI expert, Im just start getting experience using it.
can you please explain with detail that formula?.
Probably I can explain better what I looking.
For example, this is my table with data:
| Parameter | Nominal | Tolerance | Pp | Ppk | Min | Max |
| Q1 Maximum Inyection Pressure | 800 | 200 | 1.324 | 2.482 | 600 | 1,000 |
| Q2 Pressure/vp changeover | 700 | 200 | 0.425 | 0.800 | 500 | 900 |
| Q3 Melt Cushion | 2.500 | 1.00 | 0.284 | 0.325 | 1.50 | 3.50 |
| Q4 Water Delta Pressure | 5 | 1.00 | 0.443 | 0.417 | 3.50 | 5.50 |
| Q5 Water Delta Temperature | 14 | 2.20 | 0.251 | 0.366 | 11.8 | 16.2 |
| Q6 Mass Temperature | 235 | 20 | 0.268 | 0.205 | 215 | 255 |
| Q7 Dosing Time | 1.76 | 0.15 | 0.166 | 0.327 | 1.61 | 1.91 |
then I will like to create a Card showing "only" one Value from my data table.
for example, I would like to Create a Card that shows:
"For the parameter "Q1" the Pp = 1.324.
and can view like this:
Q1 Maximum Injection Pressure Pp= 1.324 |
this is what I looking for.
note:
Sorry, just to mention that this table is coming from a data base that calculated already a six sigma process, and that table has the global results. And my goal is to create a report showing the Pp & Ppk values using Cards Visuals.
Best regards.
Luigirobert.