Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago

New Column With Switch Statement Errors

I have this Switch Statement that I put in a measure and it works fine in the measure for showing the results of "Low", Med", High".  But I wanted to use the same formula in a column so that I could ...
Add Column
column
switch
VahidDM's avatar
VahidDM
Super User
1 year ago

Hi   

Can you share the details of  [Gross Adds]?

BTW, can you use the column name rather than the measure refrence in the calculated column or add that measure explanation directly in the calculated column DAX query?

 

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

  • BrianNeedsHelp's avatar
    BrianNeedsHelp
    Resolver I
    1 year ago

    Hi.  [Gross Adds] is like an aggretate of new subscribers to a newspaper.  I'm not sure what you mean by adding that measure explanation directly. I'm new to this, so i just clicked on add column and named it GACategory.  It put an fx next to the name and I just checkmark the box to add it to the visual.  That's when the whole visual goes blank and i get that error.  

    • VahidDM's avatar
      VahidDM
      Super User
      1 year ago

      Would you please share that [Gross Adds] DAX query here?

      • BrianNeedsHelp's avatar
        BrianNeedsHelp
        Resolver I
        1 year ago

        Well it just shows up as a field in the table 'Subscriber Activity'.  I don't see any query.  I was just given access to this  a couple weeks ago, so I'm not certain if i have any other access except building reports if that makes sense.