Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
hi @esuryahadi ,
then try like:
measure =
IF(
ISFILTERED(data[Title RK]) || ISFILTERED(data[Field]),
SUM(data[Progress]),
0
)
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
)
Thank you so much.
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |