I want to divide Measure 1 by Measure 2 --> Measure 1 / Measure 2.
Further information - Measure 1 = 687
- Measure 2 = 988
I get as a result : 49,59% while it should be 69,53%
Hi @Zakaria_1980 ,
You can try to use Var to make variables
divide = var _1=[Act_Current_Qtr] var _2=[Current_Qtr_Progres] return DIVIDE(_1,_2)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are the 687 and 988 results being returned by the 2 measures correct? If yes, then ensure that there are no additioal filter/slicers on that visual/page/report.
There's no way i can help you/find out the error with a screenshot.
Are you sure Measure 1 and Measure 2 are returning the result that you expect and show above? I bet they aren't. If they were, the division should be straightforward and certainly yield the correct result.
Share the pbix if possible
|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.
please find below the snapshots of the 2 measures as well as the graph. you will notice that the % in the graph is wrong. i don't know why.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.