topic Re: 25% Variance between columns in DAX Commands and Tips

25% Variance between columns

spandy34 — Sat, 21 Oct 2023 09:01:44 GMT

I have a table that records visits and records the planned hours per visit and the actual hours carried out.

I want a measure that calculates the number of records where the actual hours is 25% more than planned and another measure that calculates the number of records that were 25% less . Can anyone help me with these two measures please

littlemojopuppy parry2k HarishKM amitchandak tamerj1

Re: 25% Variance between columns

tamerj1 — Sat, 21 Oct 2023 13:01:53 GMT

Hi spandy34

please try

Measur1 =
COUNTROWS (
FILTER ( 'Table', 'Table'[Actual Hours] >= 'Table'[Planned Hours] * 1.25 )
)

Measur1 =
COUNTROWS (
FILTER ( 'Table', 'Table'[Actual Hours] <= 'Table'[Planned Hours] * 0.75 )
)

Re: 25% Variance between columns

spandy34 — Sat, 21 Oct 2023 18:02:34 GMT

Thats fabulous its worked - I really appreciate your help as always.

Re: 25% Variance between columns

littlemojopuppy — Mon, 23 Oct 2023 02:08:31 GMT

spandy34 everyone who offers solutions to the forum does so of their own time and effort. Some people try to teach better ways of doing things, others are just after accumulating points to maintain their status. But one thing most of us appreciate is the person asking the question to try to solve it by them self first. I made a suggestion in your previous post and you just asked the question for someone else to answer, and also had the audacity to tag me in the post as if I would be there to jump and solve this fairly basic question for you, along with @parry2k @HarishKM @amitchandak @tamerj1.

Some might like the opportunity to just accumulate points, but most of us aren't interested in being used because you're too lazy to try. In the future, please refer to Greg_Deckler post on how to get your posts answered. And remember that most of us like to see someone attempt to solve their problems instead of "do this for me".

Just a thought 🤣

Re: 25% Variance between columns

spandy34 — Tue, 24 Oct 2023 16:16:36 GMT

I am very sorry for offending you. It wasnt my intention. I posted the question in Desktop and you answered it in which I thanked you greatfully. I then asked another question and needed to get an answer due to a tight deadline and realised I had posted the question on Deskop as opposed to DAX query so I asked the question there. I have no idea about accumulating points and how they work as I am about learning from experts like yourself. These questions may be basic to you but as someone just learning I find them challenging. I tag people in who have helped me previously as I am just learning the aspects of PBI. I apoligise if the is not the correct way and would not like to cause offense, as I obviously have to you.