Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rakeshss
Frequent Visitor

Exclude 0 and blank from my Output

Hi Team,

 

Need qucik help,

I have a measure and my ouput but I have to exclude 0 and blanks from output, I can do it in Visual level filter but instead need to get it from my measure directly, please help me.

Rakeshss_0-1715852569776.png

Monday_Snapshot_Total =
var selectedMondayDate = MIN(KH_Calendar[Date])+1
VAR WeekDates   = DATEADD(KH_Calendar[Date],MAX(Frozen_Horizon[Fixed Horizon (Weeks)])*7,DAY)
VAR total = CALCULATE(SUM(EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[QUANTITY]),
WeekDates,
EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[SNAPSHOT_DATE].[Date] = selectedMondayDate)
RETURN total
 
 
Thanks!
2 REPLIES 2
hackcrr
Solution Sage
Solution Sage

Hi, @Rakeshss 

To exclude zero and blank values directly in your measure, you can modify your DAX code to return BLANK() when the result is zero or null. This way, you won't need to rely on visual-level filters. Here's an updated version of your measure:

Monday_Snapshot_Total =
VAR selectedMondayDate = MIN(KH_Calendar[Date]) + 1
VAR WeekDates = DATEADD(KH_Calendar[Date], MAX(Frozen_Horizon[Fixed Horizon (Weeks)]) * 7, DAY)
VAR total = CALCULATE(
    SUM(EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[QUANTITY]),
    WeekDates,
    EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[SNAPSHOT_DATE].[Date] = selectedMondayDate
)
RETURN IF(total = 0 || ISBLANK(total), BLANK(), total)

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@hackcrr ,

 

Thanks for your response ,
After modifying I still see blanks

Rakeshss_0-1715865614563.png

Solver Quantity =
VAR selectedMondayDate = MIN(KH_Calendar[Date]) + 1
VAR WeekDates = DATEADD(KH_Calendar[Date], MAX(Frozen_Horizon[Fixed Horizon (Weeks)]) * 7, DAY)
VAR total = CALCULATE(
    SUM(EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[QUANTITY]),
    WeekDates,
    EU_OMP_PROD_LOC_PLANVIEW_DAILY_FACT[SNAPSHOT_DATE].[Date] = selectedMondayDate
)
RETURN IF(total = 0 || ISBLANK(total), BLANK(), total)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.