Help for card visual

[esuryahadi]

I have the following data,

Title RK	Progress	Field
FPP FSA AGN	68,48	SS
FPP FSA SS	62,35	SS
Bridge SS	4,61	TSS
Submarine (UMHK)	11,32	TSS
Workshop RAM Field	90	SS
Renovasi Mess	52,01	SS
2 Unit Boiler	0	TSS

I want to display in a visual card only the respective progress values. When I select one of the Bridge SS examples, the value will appear as 4.61. If there is no choice, the value will appear as 0. I have difficulty with this because if there is no choice, the SUM amount from the progress column will appear.

[FreemanZ]

hi @esuryahadi ,

try to plot the card visual with a measure like:

measure = 
IF(
    ISFILTERED(data[Title RK]),
    SUM(data[Progress]),
    0
)

it worked like:

[esuryahadi]

Thank you, but i have little problem.

how if filter by field ?

[FreemanZ · Accepted solution]

hi @esuryahadi ,

then try like:

measure = 
IF(
    ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]),
    SUM(data[Progress]),
    0
)

[esuryahadi]

Thank you so much.