Forum Discussion

HemanthV's avatar
HemanthV
Icon for Helper II rankHelper II
4 years ago
Solved

ALLEXCEPT is not working for virtual column

Hi Guys,   I am facing issue to get denominator to calculate percentage, i don't have any issue with Numerator since it is just a distinct count of projects but i am facing issue with denominator. ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi HemanthV ,

     

    I'd suggest you create a new table and then create a measure separately:

    Summarized = SUMMARIZE('Table','Table'[Axis],'Table'[Value],"Count", DISTINCTCOUNT('Table'[Project Name]))
    Measure = CALCULATE(SUM(Summarized[Count]),FILTER('Summarized',[Axis]=MAX('Table'[Axis])))

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

HemanthV , change this and try

var denominator = CALCULATE( SUMX(filter(virtable,[Axis] =max([Axis])),[Count]))