Forum Discussion

getitout's avatar
getitout
Icon for Helper I rankHelper I
6 years ago
Solved

Use Calculated Fields as rows

Hi, I am very new to Power BI and I need your advice. I have many calculated fields which need to combine and present in rows for example Expected Output Name  Evaluation_Period KPI1 Mr A   Q1  ...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, i create a sample to test:

    Then try to create a new calculated table:

    Table 2 = UNION(DISTINCT(SELECTCOLUMNS('Table',"New Evaluation_Period",'Table'[Evaluation_Period ])),DATATABLE("E",STRING,{{"Result"}}))

    It shows:

    Then try this measure:

    New KPI1 = IF(SELECTEDVALUE('Table 2'[New Evaluation_Period]) = "Result",MAX('Table'[Result]),CALCULATE(SUM('Table'[ KPI1]),FILTER('Table','Table'[Evaluation_Period ] = SELECTEDVALUE('Table 2'[New Evaluation_Period]))))

     The result shows:

    Here is my test pbix file:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

According to your description, i create a sample to test:

Then try to create a new calculated table:

Table 2 = UNION(DISTINCT(SELECTCOLUMNS('Table',"New Evaluation_Period",'Table'[Evaluation_Period ])),DATATABLE("E",STRING,{{"Result"}}))

It shows:

Then try this measure:

New KPI1 = IF(SELECTEDVALUE('Table 2'[New Evaluation_Period]) = "Result",MAX('Table'[Result]),CALCULATE(SUM('Table'[ KPI1]),FILTER('Table','Table'[Evaluation_Period ] = SELECTEDVALUE('Table 2'[New Evaluation_Period]))))

 The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto Zhi