Forum Discussion

Kurumi0418's avatar
Kurumi0418
Helper I
8 years ago
Solved

How to make Column = Measure values????

  Hello everyone,   I have question, How to make Column = Measure values????   Because I want use measure show to X axis.    thanks.
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Kurumi0418,

     

    "First : I don't know why I use same rule, but value is different ( Measure & Column)"

    <--  Sum in measure will aggregate values based on other columns while calculate column will not.

     

    Second : I use ALLEXCEPT function in Column, so value is the same with Measure, But if I filiter any Feature, It's donesn't change.

    <-- Dynamic calculate column is not supported in power bi. If you want to achieve dynamic values in chart, you should use measure instead. Refer to: Dynamic column based on slicer selection

     

    Regards,

    Jimmy Tao

  • Thejeswar's avatar
    Thejeswar
    8 years ago

    Kurumi0418,

    First of all, I didn't specifically IF RuleOut = 0, because, 0 divided by anything will automatically become 0 and hence only handling divide by 0 for WIP is enough

     

    Secondly, the Values are coming right when using the DAX I shared earlier as shown below. Here I have added two of my own values to show you the scenarios.

    Both Column and Measure displayed

     

     

    The Below are the DAX Statements that I used for Column and Measure

     

    Column = IF(WAITING_TIME_REPORT_HISTORY[WIP] = 0, 0, DIVIDE(WAITING_TIME_REPORT_HISTORY[Rule Out],WAITING_TIME_REPORT_HISTORY[WIP])) 
    Measure = IF(SUM(WAITING_TIME_REPORT_HISTORY[WIP])=0, 0, DIVIDE(SUM(WAITING_TIME_REPORT_HISTORY[Rule Out]), SUM(WAITING_TIME_REPORT_HISTORY[WIP]))) 

    So it shouldn't be a problem with the DAX statement used. May be something else is causing the issue.