cancel
Showing results 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

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:

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.
1 ACCEPTED SOLUTION
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() ))

3 REPLIES 3
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() ))

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)

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.

Announcements

#### 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 Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors