Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hello,
I have the measure
Solved! Go to Solution.
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.
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.
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 ?
Help when you know. Ask when you don't!
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)
Help when you know. Ask when you don't!
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |