- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Community Information
- Community Accounts & Registration
- Using the Community
- Community Feedback
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Help with Simple DAX formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

sqldev2017

Regular Visitor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
07:53 AM

I am doing something like this -

PreviousMonth = FORMAT(CALCULATE(MIN(DimDate[Month]), FILTER(DimDate, DimDate[Month_Year] = [SelectedMonthYear]) ), "String")

- Min(DimDate[Month]) returns a string ... I can see it returns the right string.

But when i now use this calculated "Measure" (PreviousMonth) - in another formula , the result of that formula returns BLANK .... When I replace this measure (in that other formula), with a hard coded string , that formula returns the right result !

What am i doing wrong ?

I have tried every kind of thing, it doesn't work !

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Zubair_Muhammad

Super User

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:02 PM

Try storing the MEASURE value in a variable first

Revenue = VAR myMEASURE = [MonthYear] RETURN CALCULATE ( SUM ( fact[Revenue] ), FILTER ( fact, fact[fiscalMonth] = myMEASURE ) )

7 REPLIES 7

MFelix

Super User

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:15 AM

Hi @sqldev2017,

What do you want to use this measure for? what is the context and calculation you arre making on the other measure where this one is used?

Regards,

MFelix

Proud to be a Datanaut!

sqldev2017

Regular Visitor

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:24 AM

I simply want to return one string value from a table, based on a filter.... That filter will always return one string value (for that table).

I understand CALCULATE is only for numeric measures...

But in this instance CALCULATE also seems to return a string !

MFelix

Super User

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
09:56 AM

Hi @sqldev2017,

Calculate is not only for numeric it can be used in very different ways and the result will be variable text, numbers, etc.

You say in your post that you want to use the measure you calculated in another measure what is exactly your needs? Can you share sample data, setup expected result.

Regards

Mfelix

**Did I answer your question? Mark my post as a solution!**

Calculate is not only for numeric it can be used in very different ways and the result will be variable text, numbers, etc.

You say in your post that you want to use the measure you calculated in another measure what is exactly your needs? Can you share sample data, setup expected result.

Regards

Mfelix

Proud to be a Datanaut!

sqldev2017

Regular Visitor

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
07:37 PM

I am doing something pretty straightforward.

My first "calculated measure" "MonthYear" returns a value say = "December 2018"

I use this calculated measure "MonthYear" in a different calculated measure as a Filter parameter -

"Revenue" = CALCULATE(SUM(Revenue), FILTER("fact", fact.fiscalMonth = MonthYear))

I can verify that MonthYear measure actually returns "December 2018"

But Revenue measure returns a blank value.

When I replace the MonthYear parameter , with a hard coded value

"Revenue" = CALCULATE(SUM(Revenue), FILTER("fact", fact.fiscalMonth = "December 2018" )) - Now this returns proper revenue value.

I do not understand why this is happening ! This is just so Bizzare.

Zubair_Muhammad

Super User

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:02 PM

Try storing the MEASURE value in a variable first

Revenue = VAR myMEASURE = [MonthYear] RETURN CALCULATE ( SUM ( fact[Revenue] ), FILTER ( fact, fact[fiscalMonth] = myMEASURE ) )

sqldev2017

Regular Visitor

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:06 PM

That worked like a Charm.

Thank You.

Honestly, I was trying to do this FORMAT(Measure, "String") , that was not working.

This worked.

Zubair_Muhammad

Super User

Re: Help with Simple DAX formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-01-2018
08:17 PM

Glad it worked.

When you use a MEASURE inside a FILTER function, it is evaluated for each row of the Table inside FILTER function (in your case it is FACT table)

That's why we have to store its value first in a variable

FILTER ( fact, fact[fiscalMonth] = [Measure] ) )