Card visual showing one value coming from a specific data cell (Row-column).

[LuigiRobert]

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.  

[amitchandak]

@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") )

[LuigiRobert]

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.