Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

adding measures from other tables into one column

I have one powerBi report, with mutliple tables. Within each table is a measure. I've created a final report that has Code, Location, Data. I need to measures to be reported (in data field) based on the date slected. I've used COALESCE but it doesn't pull all the measures.

Relat = COALESCE('Reservoirs'[Res depth ft],'Partial Flume'[Daily Flow (AF)],'Treatment Plant'[Plant_Daily_AVG])
How do I get it pull all the measures from different tables to report in the one column? 
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Anonymous 

     "COALESCE()" function Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned. This is just will return one value when meet it logic.

    For this , you can refer to :
    COALESCE function (DAX) - DAX | Microsoft Learn

    The first thing to be clear is that there is no table distinction for measures.

    Measure is a formula, calculated according to the filtering context you put on visual.

    Secondly, generally one cell displays one value, and cannot display the calculated values of multiple measurement values.

     

    And measure is calculated according to the current filtering context, different filtering contexts may calculate different values. Problems can arise if your measures are calculated on different tables and there is no relationship between those tables.
    If you want to customize the dimension, you can create a dimension table, and then use the SWITCH() function to make a judgment and return the corresponding measurement value. Only then will the 3 measures appear in one column.
     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , Anonymous 

     "COALESCE()" function Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned. This is just will return one value when meet it logic.

    For this , you can refer to :
    COALESCE function (DAX) - DAX | Microsoft Learn

    The first thing to be clear is that there is no table distinction for measures.

    Measure is a formula, calculated according to the filtering context you put on visual.

    Secondly, generally one cell displays one value, and cannot display the calculated values of multiple measurement values.

     

    And measure is calculated according to the current filtering context, different filtering contexts may calculate different values. Problems can arise if your measures are calculated on different tables and there is no relationship between those tables.
    If you want to customize the dimension, you can create a dimension table, and then use the SWITCH() function to make a judgment and return the corresponding measurement value. Only then will the 3 measures appear in one column.
     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly