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

Helper III

## Wee bug found

When using the not(isblank) function within a calculate it doesnt seem use the other filters in the calculate.

1 ACCEPTED SOLUTION
Community Support

Hi @jak8282 ,

Try to modify your formula like below: In this modified expression, we use Evaluation[Scorecard] <> "other" to filter records where the Scorecard column is not equal to "other".

``````QMS Procedural Pass Score1 =
CALCULATE(
COUNT(Evaluation[Date]),
Evaluation[Process Result] = "Pass",
Evaluation[Scorecard] <> "other",
USERELATIONSHIP('Date'[Date], Evaluation[Date])
)
``````

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

Hi @jak8282 ,

Try to modify your formula like below: In this modified expression, we use Evaluation[Scorecard] <> "other" to filter records where the Scorecard column is not equal to "other".

``````QMS Procedural Pass Score1 =
CALCULATE(
COUNT(Evaluation[Date]),
Evaluation[Process Result] = "Pass",
Evaluation[Scorecard] <> "other",
USERELATIONSHIP('Date'[Date], Evaluation[Date])
)
``````

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@jak8282 Well, CALCULATE after all... Any chance you can provide more information so that the problem can be recreated?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Helper III

It was with code

QMS Procedural Pass Score =
CALCULATE(
COUNT(Evaluation[Date]),
Evaluation[Process Result] = "Pass",
NOT(Evaluation[Scorecard])= "other",
USERELATIONSHIP('Calendar Date'[Date],Evaluation[iDayID]))

never knew calculate was was to use..

With the NOT it was bringing back all the scorecards

scorecard 1   |     72%

scorecard 2   |     72%

scorecard 3   |     72%

scorecard 4  |     72%

However with the blank in the filter section instead it brought it back correctly

scorecard 3 |  72%

HTH

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