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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
69 | |
36 | |
21 | |
17 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
23 |