Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create DAX table with % calculation

Hello,   I need your support with the next issue please. I have the next 2 tables. I want to create a 3rd table, calculating for every Audit type, the % of the number of companies in column (comp...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Anonymous ,

    what about the following solution:

     

     

     Regards FrankAT

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous I believe you want something like:

Table C = 
ADDCOLUMNS(
  ADDCOLUMNS(
    SUMMARIZE(
      'Table B',
      [Audit type],
      "Number of companies",COUNTROWS(DISTINCT('Table B'[Company]))
    ),
    "Important company in",COUNTROWS(ALL('Table A'),[Classification]="Important")
  ),
  "%",[Number of companies] / [Important company in]
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello,

 

Thanks for the solution it is working (after a small correction in line 8 - missing 'FILTER').

 

BR.