Forum Discussion

evalromf's avatar
evalromf
Helper I
9 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi GilbertQ BeforeOn using new measure

 

The new measure is not working fine as the report contains columns from some other tables like T1, T2.

 

Can you suggest on this 

 

 

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

If you can post some sample data, with the measures we can then assist?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi GilbertQ 

     

    Its difficult to post data as it is coming from two or three tables and they contain many columns. But can you explain why i am not able to put a simple condition.

     

    Example if am i am doing (billing = "FP") it should not give at row level but at the aggregated level without being affected by other columns in the report.

     

    How can i create a measure so that it gives billing = FP without getting affected by any dimension??

     

     

    • GilbertQ's avatar
      GilbertQ
      Super User
      6 years ago
      Hi there

      I would suggest first to simplify your model design if you are trying to achieve this from 2-3 different tables. Ideally all that information would be contained in 1 table.

      The challenge is that when creating a measure it does not work on a column basis but rather works on returning a single scalar value. With the IF condition it still expects to get a single value once evaluated?
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        GilbertQ  Below is the error i am getting. Now i am getting the data from 2 tables project, staff and calendar table is also used. Can you now suggest on this.

         

        ErrorProjectSchema