Values if an other value is not blank

[Anonymous]

Hi, I have a problem.
I want to delete SqMeters values when Sold has no values.

What i want:

I have tried different measures but if I try to write:
IF([Sold], sum[SqMeters])

or

Sold/Sqm =
CALCULATE(
sum([SqMeters],
FILTER ( VALUES ( Table[Store] ), [Sold] <> BLANK () )
)

these measures always return me an error where it tells me that the memory required for this calculation exceeds the available memory or a generic error.

How could I write a measure so that the SqMeters value is removed when Sold is blank?

Thank you!

[Anonymous]

Hi @Anonymous ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the new measure to filter no values.

Sold no values = IF(VALUES('Table'[Sold]) <> BLANK(), 1, 0)

3.Drag the measure to the Filters pane and set show items is 1.

4.The result is shown below.

Best Regards,

Wisdom Wu

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

[Anonymous]

Thank you, for your help but i want that measure works with a filter inside the measure, because i want the information in a card.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try the following methods again:

SqM = CALCULATE(SUM('Table'[SqMeters]), FILTER('Table', 'Table'[Sold] <> BLANK()))

Best Regards,

Wisdom Wu

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

[Anonymous]

Please someone can help me?

[foodd]

Remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

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.

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

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.