Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |