Forum Discussion

mit1's avatar
mit1
Helper I
2 years ago

1 Measure multiple columns in a table visual

Hi all,


May I ask if it is possible to create a single measure that displays 4 separate distinct columns?

(i.e. take the 4 columns from my dataset, and display in a table visual using 1 measure)

Thank you in advance!

 

Need Help
Show and Tell
Tutorial Requests

4 Replies

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi,

    I didn't undertand your idea. Can you provide an example with the final output?

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi mit1 


    BTW, You can have different columns in single measure. but didnt understand your need. what exactly you want to display with 4 columns? 
    like is it sum of all 4 columns??

     

     

    • mit1's avatar
      mit1
      Helper I
      2 years ago

      Hi Uzi2019, _AAndrade & Anonymous , thank you for your reply!

      This is the output visual im looking for (4 different column output)

       

      Was hoping that i could use a single DAX measure in the "Column" input of the table visual, instead of 4 measures (i.e. 1 measure = 4 columns, not 4 measure = 4 columns or 1 measure = 1 combined column).

       

      Goal is to use a measure to call the columns from the dataset into the table visual, instead of using the column straight from the dataset itself.

      Thank you once again!

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, mit1 

     

    If your goal is to display 4 different values in a single column of your table visual, you might consider creating a calculated column that connects the values of those columns. Instead of using measures, this method uses DAX formulas in calculated columns to combine text from multiple columns. For example:

     

    Concatenated Column = [Column1] & ", " & [Column2] & ", " & [Column3] & ", " & [Column4]


    This will create a new column in the model that is available in the table visual. For more information about calculated columns, you can refer to the following documentation:

     

    Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

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