Page no longer filtering after measure added

[ebrownretail]

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:

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

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.

[ebrownretail · Accepted solution]

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]

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]

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