Forum Discussion

cottrera's avatar
cottrera
Post 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

PijushRoy's avatar
PijushRoy
Community Champion
4 years ago
Please use the Calculation 

Measure = VAR HardNum = 2508
VAR CategoryPercent = SELECTEDVALUE('Table'[% Split])
Return
HardNum * CategoryPercent

IF SOLVED, PLEASE GIVE KUDO


  • cottrera's avatar
    cottrera
    Post Prodigy
    4 years ago

    Hi PijushRoy
    Thank you for responding. Unfortunatly this does not resolve me issue as the percentages I am using already come from a DAX functionand cannor be uses here ('Table'[% Split])

     

    The table I showed in my example is a visual table not a data base table the % split is a DAX function