topic Re: Values if an other value is not blank in DAX Commands and Tips

Values if an other value is not blank

Anonymous — Mon, 08 Jul 2024 10:25:46 GMT

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])

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!

Re: Values if an other value is not blank

foodd — Mon, 08 Jul 2024 10:31:11 GMT

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-Forum/ba-p/963216

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/1447523/highlight/true#M607150

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

Re: Values if an other value is not blank

Anonymous — Mon, 08 Jul 2024 10:49:34 GMT

Please someone can help me?

Re: Values if an other value is not blank

Anonymous — Tue, 09 Jul 2024 08:46:42 GMT

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.

Re: Values if an other value is not blank

Anonymous — Tue, 09 Jul 2024 09:28:39 GMT

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.

Re: Values if an other value is not blank

Anonymous — Tue, 06 Aug 2024 07:12:51 GMT

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.