none
Find percentage of Total using DAX

    Question

  • How to add a 4th column, calculated column of percent total, to a simple table with a date column, type column, and count column to allow slicing and dicing?

    i.e.

    date        type    count
    2013/01/01    usa    1
    2013/01/01    mex    1
    2013/01/01    jap    0
    2013/02/01    usa    1
    2013/02/01    mex    0
    2013/02/01    jap    1

    I have a time slicer on Date; don't have a time dimension.  The result will be liked

    type 2013-01   2013-02    2013-03
    jap  0        50%    30%
    mex  50%    0    30%
    usa  50%    50%    30%

    I have tried defining a new column as
    =calculate(sum([count]), ALLEXCEPT(myTbl, myTbl[type], myTbl[date]))

    The data isn't what I am looking for.


    -- IBM has jobs for USA employee to work oversea (India) and get their wages.


    • Edited by light_wt Tuesday, September 10, 2013 7:56 PM
    Tuesday, September 10, 2013 7:53 PM

Answers

All replies