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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
elia22gr
Helper II
Helper II

Filter the values (outcome) of a calculation group

Hi all!

 

I have a Power BI report and I ve created 2 calculation Groups in Tabular Editor

 

The first one holds my measures such as Act Sales, Target, LY Sales, LY-1 Sales, % vs. Target etc called "Metrics" and the second calculation group holds the MTD, QTD, YTD etc called "Time Intelligence".

 

In my report I have a table with columns the Metrics Calculation Group (and I have a slicer to let viewer choose what they want to see) and the columns are also dynamic with the use of field parameters. I have also one slicer with the Time Intelligence so they see all the measure in the Period they chose (MTD, QTD, YTD etc).

 

But I want to offer a cleaner view and make the blanks and zeros disappear from my table. If the Act Sales are 0 or blank I want this row not showing (lets say that in the rows we have products). So, if one products Act Sales are 0 this product I don't want to appearing in the table.

 

How can I make it work?

 

Thank you in advance!

3 REPLIES 3
PierreL69
Helper III
Helper III

It works thanks 

Kind regards,

Pierre

elia22gr
Helper II
Helper II

@amitchandak No they don't. Act Sales is part of a calculation group not a measure itself. So, if it is zero or blank they don't disappear. I want to filter away the blanks and zeros of the calculation Item Act Sales part of a calculation group. Also, I tried to use a a measure as filter but it didn't worked...

 

Any ideas?

amitchandak
Super User
Super User

@elia22gr , Blank should go away automatically. so usually this what we do

 

if([sales] =0 , blank(), [sales]) //measure

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors