Forum Discussion
Card visual showing one value coming from a specific data cell (Row-column).
Hello All.
I have a question, I want to make a report using visuals cards showing just a value. But that value is in a specific data cell.
do you know which formula I can used?
thank you.
Robert.
2 Replies
- amitchandak
Super User
LuigiRobert , 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.
