Forum Discussion

Paulompm's avatar
Paulompm
Frequent Visitor
9 years ago
Solved

Conditional percentage using DAX

Hello everyone, need to get the percentage value that represents each day within the month by product type using dax formula(s). E.g.:                          Sample:   Date ...
Need Help
Tutorial Requests
  • spuder's avatar
    spuder
    9 years ago

    Hi Paulompm,

     

    I think this measure would give you your result you wish to have.

     

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Paulompm

     

    Hi, try with this:

     

    %ByDay =
SUMX (
    Table1,
    DIVIDE (
        CALCULATE ( SUM ( Table1[Value] ) ),
        CALCULATE ( SUM ( Table1[Value] ), ALLEXCEPT ( Table1,Table1[Product Type] ) )
    )
)
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Paulompm

 

Hi, try with this:

 

%ByDay =
SUMX (
    Table1,
    DIVIDE (
        CALCULATE ( SUM ( Table1[Value] ) ),
        CALCULATE ( SUM ( Table1[Value] ), ALLEXCEPT ( Table1,Table1[Product Type] ) )
    )
)