Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
22 | |
19 | |
12 | |
10 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |