Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

DAX percentage Query

Hi    I have a hard coded number 2,508   I also have a table visual for which the % figure will change daily. Trade % Split Elec 30% Multi 51% Plumbing 10% ROUTINE_EXTERNAL 0...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi cottrera ,

    Please try this:-

    Measure =
VAR Num = 2508
RETURN
    ( Num * ( [% Split] * 100 ) ) / 100

    Thanks,

    Samarth

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

Hi cottrera ,

Please try this:-

Measure =
VAR Num = 2508
RETURN
    ( Num * ( [% Split] * 100 ) ) / 100

Thanks,

Samarth

  • cottrera's avatar
    cottrera
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Thank you Samarth_18 for replying quickly your method worked fine