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

The 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.

Reply
josevaras
Microsoft Employee
Microsoft Employee

Filter Measure Results

Hello,

 

I have the measure 

DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1
which returns, amongst others values, a -100. I would like to filter out the -100 out of the result set. I am using a Matrix that has as row values country names, values as total sales and on my column header, the measure above.

Thank you for your help. 
1 ACCEPTED SOLUTION
TheDataMustFlow
Frequent Visitor

Hi @josevaras ,

 

A possible approach would be to nest the DIVIDE within an IF:

 

= IF(

     DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1=-100,

     BLANK(),

     DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1

)

 

Thatt should filter out the results where the DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1 returns -100.

 

 

View solution in original post

4 REPLIES 4
TheDataMustFlow
Frequent Visitor

Hi @josevaras ,

 

A possible approach would be to nest the DIVIDE within an IF:

 

= IF(

     DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1=-100,

     BLANK(),

     DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1

)

 

Thatt should filter out the results where the DIVIDE([Total Sales LM] , [Sum Total Sales] ) -1 returns -100.

 

 

kentyler
Solution Sage
Solution Sage

I assume you have this in some sort of table visual. Do you want to not show the -100 value, or not include the whole row where the divide returns -100 ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


I would like the whole row to not show up

Do you know what it is about that row that gives the minus result ? I don't think the DIVIDE function can make the row not show up. Perhaps if it returned a blank value that might cause the row not to be included. If so, you could wrap the DIVIDE in an IF() and return blank if the result was less than 0)





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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