Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have set a mesure show zero to the card visual when select a particular Status.
Example, I select status "Healthy" from filter. My other card visual should have change to "0".
Now, when I select a status, the other card visual remain with same value. It doesn't change to 0.
Here's my current measure that I set:
"Healthy 2 = IF(ISBLANK(CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy")), 0, CALCULATE(COUNT(Table10[Result 2]), Table10[Result 2] = "Healthy"))"
Solved! Go to Solution.
Hi @pravind96 ,
We can use the following measures to fix it:
Healthy =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Healthy"
) + 0
Infected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Infectet"
) + 0
Precaution =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Precaution"
) + 0
Suspected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Suspected"
) + 0
Add a 'Table10', in the calculate formula.
Best regards,
Hi @pravind96 ,
We can use the following measures to fix it:
Healthy =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Healthy"
) + 0
Infected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Infectet"
) + 0
Precaution =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Precaution"
) + 0
Suspected =
CALCULATE (
COUNT ( 'Table10'[Result 2] ),
'Table10',
'Table10'[Result 2] = "Suspected"
) + 0
Add a 'Table10', in the calculate formula.
Best regards,
Hi, thanks for the answer. It works.
I found this code earlier. It works too.
Try:
Healthy 2 =
VAR __MyVar =
IF(
ISBLANK(
CALCULATE(
COUNT(Table10[Result 2]),
Table10[Result 2] = "Healthy"
)
),
0,
CALCULATE(
COUNT(Table10[Result 2]),
Table10[Result 2] = "Healthy"
)
)
RETURN
IF(ISBLANK(__MyVar),0,__MyVar)
If that doesn't work, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
It's still showing the same results as mine. Other card visual doesn't show 0.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |