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
ebrownretail
Resolver I
Resolver I

Page no longer filtering after measure added

Hi!

I am trying to use measure to help me determine what i need to order for a product. Everything is filtering correctly (filters are at the page level for a specific item number and store status). However when i add in this measure it no longer filters down to what I want. 

 

Any help would be appreciated!

 

Before measure is added - 328 store showing, and only those stores:

ebrownretail_0-1722700497928.png

 

After measure is added - more stores showing that is not part of the 328:

ebrownretail_1-1722701168736.png

 

Measure:

Build Order =
IF([Build Need] > 200, MROUND([Build Need], 450), IF(SELECTEDVALUE('Club Alignment'[Item Number], 533841), IF(SELECTEDVALUE('Club Alignment'[Status], 1), IF([Total Pipe] < 1, 450, BLANK()), BLANK()), BLANK()))
 
Only for Item # _____ and for clubs with a status of 1
i want it to look at the build need and if more than 200 is needed to order to the nearest 450.
If less than 200 is needed and they have on hand i want it to be 0 or blank.
If there is nothing in the pipeline and its less than 200 need i want it to be 450.
1 ACCEPTED SOLUTION
ebrownretail
Resolver I
Resolver I

I figured it out. I had to do a Sumx formula in a seperate measure to find the status. Then i could use that measure in my formula. Example below. 

 

I have a club table that get pulls into my visual that only lists club information. 

I have a seperate table that lists what the club status is 0 for inactive and 1 for active. Make sure this is a number column. 

I used this measure to find the club status as a measure Curr Status = CALCULATE(SUMX('Club Alignment', 'Club Alignment'[Status]))

 

Using that new measure, i was then able to list my if formulas and keep my status showing for only active clubs. 

 
Build Order =
IF([Build Need] > 200, MROUND([Build Need], 450), IF([Curr Status] = 1, IF([Total Pipe]<30, 450, BLANK()), BLANK() ))

 

View solution in original post

3 REPLIES 3
ebrownretail
Resolver I
Resolver I

I figured it out. I had to do a Sumx formula in a seperate measure to find the status. Then i could use that measure in my formula. Example below. 

 

I have a club table that get pulls into my visual that only lists club information. 

I have a seperate table that lists what the club status is 0 for inactive and 1 for active. Make sure this is a number column. 

I used this measure to find the club status as a measure Curr Status = CALCULATE(SUMX('Club Alignment', 'Club Alignment'[Status]))

 

Using that new measure, i was then able to list my if formulas and keep my status showing for only active clubs. 

 
Build Order =
IF([Build Need] > 200, MROUND([Build Need], 450), IF([Curr Status] = 1, IF([Total Pipe]<30, 450, BLANK()), BLANK() ))

 

mostho
Helper II
Helper II

I think you have to add "and not blank" criteria to your filters. (i had a similar issue where this was the solution which solved my problem)

lbendlin
Super User
Super User

Measures can only impact a visual, not an entire page. 

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

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.