Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
3 years ago
Solved

Division in Model

I have created a new measure like this: ArchiveTotal = SUMX(Summaries, Summaries[FreeAmount] + Summaries[UsedAmount])   Now I want to calc the percentage of FreeAmount and UsedAmount over Arc...
Need Help
  • AlB's avatar
    AlB
    3 years ago

    Markzolotoy

    Using your existing measure [ArchiveTotal]:

    NewMeasure =
VAR usedAmount_ = SUM(Summaries[UsedAmount])
RETURN
DIVIDE(usedAmount_, [ArchiveTotal])

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Markzolotoy ,

    Column names alone cannot be displayed in the measure, you need to bring the column names into the formula, you can try the following code:

    _ FreeAmount=divide(sum(Summaries[FreeAmount]),[ArchiveTotal])

    _ UsedAmount=divide(sum(Summaries[UsedAmount]),[ArchiveTotal])

     

    Best Regards!

    Yolo Zhu

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Markzolotoy ,

Column names alone cannot be displayed in the measure, you need to bring the column names into the formula, you can try the following code:

_ FreeAmount=divide(sum(Summaries[FreeAmount]),[ArchiveTotal])

_ UsedAmount=divide(sum(Summaries[UsedAmount]),[ArchiveTotal])

 

Best Regards!

Yolo Zhu

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