Forum Discussion

e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
7 years ago
Solved

How apply filter in 2 different dimension tables

Hi ,   I have 2 tables, first table has "time", "A", "B", "C", "D" 4 columns. use time as filter. Now I need to create a new table. New table column is based on ABCD calculation as below:       ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    e2liu77,

     

    See code below.

    IF (
    MAX ( table2[column1] ) =
e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
7 years ago

Hi Stachu,

 

Thanks for helping me.

 

My problem is that in table 2, the colA, colB and ColC calculation is column1 value related. with different column1 label value, the formula used are different. When I am using "if(table2[column1] = "label1, formular1, if(table2[column1] = "label2", formula2,......", it always reports error "A single value for column 'Column1' in table 'FunnelTable' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

Anyway to put different calculation in 1 column based on column1 values?

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

e2liu77,

 

Just change to MAX ( table2[column1] ).

  • e2liu77's avatar
    e2liu77
    Icon for Helper I rankHelper I
    7 years ago

    Hi v-chuncz-msft,

     

    Sorry, I didn't get your point. How to use max() to switch between different text values in Column1?

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      e2liu77,

       

      See code below.

      IF (
    MAX ( table2[column1] ) =