Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a total table from an other table

Hi,   I have a data table like this :    I want to create a new table with the total (direct + toller) for each year (2021 and 2022) And the percentage of direct (direct value / direct val...
Need Help
  • vivran22's avatar
    vivran22
    4 years ago

    Hello Anonymous 

     

    I have used the following sample data:

     

     

    And created following measures:

     

    Total Value = SUM('Table'[Value])
     
    % Cat A =
    VAR _CatA = CALCULATE([Total Value],'Table'[Category] = "CAT A")
    VAR _Overall = CALCULATE([Total Value],REMOVEFILTERS('Table'[Category]))
    RETURN
    DIVIDE(_CatA,_Overall)
     
    Result:
     

     

    Hope this helps

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
4 years ago

Hello Anonymous 

 

I have used the following sample data:

 

 

And created following measures:

 

Total Value = SUM('Table'[Value])
 
% Cat A =
VAR _CatA = CALCULATE([Total Value],'Table'[Category] = "CAT A")
VAR _Overall = CALCULATE([Total Value],REMOVEFILTERS('Table'[Category]))
RETURN
DIVIDE(_CatA,_Overall)
 
Result:
 

 

Hope this helps