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
CESARPULIDOGDL
Frequent Visitor

ISSUE WITH DIVIDE -1

HI EVERYBODY

 

I HAVE A ISSUE, WHEN I USE A MEASURE THAT DIVIDE MONTH EXPENSE VS MONTH EXPENSE PREVIOUS YEAR & USE -1, THE VISUAL, HAVE A ISSUE THAT SHOW ME OTHERS YEARS THAT I HAVENT SELECTED IN THE SLICER DATE.

 

IN THE IMAGE, I CAN EXPLAIN BETTER, THE QUESTION IS HOW CAN I USE DE -1 AND DONT LOSS THE SLICER DATE.

 

REGARDS

 

 

Imagen1.png

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

@CESARPULIDOGDL ,
The issue seems to be that some results are evaluating to -1 instead of blank.
Try the below measure:

#med gasto promedio AAvsYTD = 
IF (
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1 = -1,
BLANK(),
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1
)

 

View solution in original post

3 REPLIES 3
Anand24
Super User
Super User

@CESARPULIDOGDL ,
The issue seems to be that some results are evaluating to -1 instead of blank.
Try the below measure:

#med gasto promedio AAvsYTD = 
IF (
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1 = -1,
BLANK(),
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1
)

 

thanks it really works 😁

Thanks, let me try, i will return.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors