Forum Discussion

NickProp28's avatar
NickProp28
Post Partisan
5 years ago
Solved

Select specific column and form new table

Dear Community,

Good Day !

 

I have 3 tables. Main table is Consol Detail, follow by table Consol_Contract and Consol_Time. Both of them linkange by ConsolNumber

Would like to summarize all the highlighted column and form a new table for further analysis. 

Knowing that can simply drag and drop, but I would like to have a new table. 

Outcome:

ConsolNumber from Consol_Detail table, and would like to sum up the JobNumber 

 

Attached with pbix: https://ufile.io/4sludwf3

Any help will greatly appreciated 

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey NickProp28 ,

     

    that should be possible with SUMMARIZECOLUMNS. Try the following DAX table:

    New Table =
SUMMARIZECOLUMNS(
    Consol_Detail[ConsolNumber],
    Consol_Detail[Branch],
    Consol_Detail[Dept],
    Consol_Time[ActualTime],
    Consol_Contract[CarrieContact],
    Consol_Detail[GP],
    Consol_Detail[Profit],
    "Count of Job Number",
        CALCULATE(
            DISTINCTCOUNT( Consol_Detail[JobNumber] )
        )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

1 Reply

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey NickProp28 ,

     

    that should be possible with SUMMARIZECOLUMNS. Try the following DAX table:

    New Table =
SUMMARIZECOLUMNS(
    Consol_Detail[ConsolNumber],
    Consol_Detail[Branch],
    Consol_Detail[Dept],
    Consol_Time[ActualTime],
    Consol_Contract[CarrieContact],
    Consol_Detail[GP],
    Consol_Detail[Profit],
    "Count of Job Number",
        CALCULATE(
            DISTINCTCOUNT( Consol_Detail[JobNumber] )
        )
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis