Forum Discussion

Icon for Impactful Individual rank

Impactful Individual

8 years ago

Measure for Scatter Plot Category

Hello All, Seems like this has probably been hashed out--and perhaps solved. I didn't see anything and thought it might be a straightforward Yes/No and perhaps a "here's how." I have a scatt...

Icon for Microsoft Employee rank

Microsoft Employee

8 years ago

Hi Tom,

If I understand your scenario correctly, you'd like to add a measure in the "Details". I'm afraid we can't do that. That's because the "Details" is the context of other measure. What's the result do you expect?

Best Regards,

Dale

ThomasDay
Impactful Individual
8 years ago
Hi Dale--I'm looking to add a measure to the Legend bin...that wasn't clear at all..sorry for the confusion

Right now I've put "bed size" in there which is from the same table as Facility (Details) which sets the context.

I'd like to use a slicer to select data from one of about 7 different columns--all from the same table as the Details field of Facility.

Here is an example of How I thought I'd do it but the bin for Legend does not seem to accept a measure.
ChartCategory =
VAR CatToUse = IF(HASONEVALUE(Category[Chart Category]),SelectedValue(Category[Chart Category]),"Bed Size")
Return
IF(CatToUse = "System Name",VALUES(MeasureReptRecNoProviders[SystemName]),VALUES(MeasureReptRecNoProviders[Bed Size]))

Does that help? Any ideas?
Tom
- v-jiascu-msft
  Microsoft Employee
  8 years ago
  Hi ThomasDay,
  
  How about using a calculated column instead of a measure? Can you share a sample? Maybe we can find a solution.
  
  Best Regards,
  
  Dale
  - ThomasDay
    Impactful Individual
    8 years ago
    That's a good idea. I've not created a column before...just scalars. Are you thinking of SelectColumn? And with SelectColumn, do the relationships from the base table stay in-place when it is executed? Thanks, Tom

Related content