cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sfmike
Frequent Visitor

Problem with simple measure?

I have a single table which I created from a public dataset, with the following layout / sample records:

table.PNG

Now I want to create a measure for Unemployment Rate which is based on the very simple function (Unemployed / LaborForce). I need a measure instead of a calculated column, because I want to analye the data by geography and race.

 

UERate = DIVIDE(SUM(UE1[Unemployed]), SUM(LF1[LaborForce]))

 

What's weird is that the measure always gives me the calculation for the entire table, regardless of how I slice the data using values from the same table, e.g.:

 

table2.PNG

It's rolling up my columns correctly, but the measure is ignoring my visual filter.

 

What am I doing wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Problem with simple measure?

Hi @sfmike ,

 

Looking at your measure you are making the calculation based on two different tables UE1 and LF1 if the tables don't have any relationship with the table where the Race column is based then you will get the full result for both tables so in all rows the same value since there is no context connection between the measure and the table columns.

 

I assume that when you refer that you have a single table is a new one where you have summarize your information correct?

 

You need to make the measure based on that table columns in your case Race / LaborForce / Unemployed.

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





View solution in original post

3 REPLIES 3
Super User III
Super User III

Re: Problem with simple measure?

Hi @sfmike ,

 

Looking at your measure you are making the calculation based on two different tables UE1 and LF1 if the tables don't have any relationship with the table where the Race column is based then you will get the full result for both tables so in all rows the same value since there is no context connection between the measure and the table columns.

 

I assume that when you refer that you have a single table is a new one where you have summarize your information correct?

 

You need to make the measure based on that table columns in your case Race / LaborForce / Unemployed.

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





View solution in original post

Super User IV
Super User IV

Re: Problem with simple measure?

Well, in the measure, you refer to two separate tables while your table shows both columns in the same table. Generally when a measure acts the way your is acting, there is a missing relationship between two tables.

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

sfmike
Frequent Visitor

Re: Problem with simple measure?

I'm an idiot. Those were temporary tables I used as I was working through the data.

 

All better now - thanks.

 

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors