Forum Discussion
Problem with simple measure?
Hi Anonymous ,
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.
Hi Anonymous ,
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.
I'm an idiot. Those were temporary tables I used as I was working through the data.
All better now - thanks.