Forum Discussion
Solved
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 ...
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.