Forum Discussion
Solved
Help for card visual
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.
hi esuryahadi ,
then try like:
measure = IF( ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]), SUM(data[Progress]), 0 )
4 Replies
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:
Thank you, but i have little problem.
how if filter by field ?
hi esuryahadi ,
then try like:
measure = IF( ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]), SUM(data[Progress]), 0 )
