The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have a measure as below:
TotalDenied = CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N")
Whenever the value of TotalDenied > 0, it displays fine, but when the value is 0, the report shows blank. How can I make it display 0 instead? Please see the attached screenshot. Thank you!
Solved! Go to Solution.
Hi
A simple solution : Add +0 to your formula.
CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0
P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.
Thanks
Raj
Hi
A simple solution : Add +0 to your formula.
CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0
P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.
Thanks
Raj
Hi @ppgandhi11
I hope this below calculation will help you. And check the attached Pbix here
Create seperate measures
Cases = SUM(Table1[TotalCases])
Aproved = SUM(Table1[TotalApproved])
Total Denied 1 = var denied = SUM(Table1[Total Denied]) var aproved = [Aproved] return IF(ISBLANK([Aproved]),denied ,IF(ISBLANK(denied),0,denied))
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
95 | |
74 | |
67 | |
52 | |
51 |