Forum Discussion
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...
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.
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.
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. |