cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Calculate % difference in MOM measures

Hoping this is a simple one for someone.

I have a measure that divides repeat callers by all callers within 2 days for our repeat rate.  I am diplaying that measure monthly.  I would like to calculate the difference +/- from May to June and so on. Any help is greatly appreciated.

Measure being used:

Repeat Rate = DIVIDE([1 Count Repeats],[1 Count All Calls])

Sample Data:
 Ticket Category _CSG Leg - Date Calls Point of Sale::Printing 15-Jun-24 1 Restaurant Management::Employees 16-Jun-24 1 Point of Sale::Printing 15-Jun-24 1 Point of Sale::Printing 15-Jun-24 1 Restaurant Management::Licensing 15-Jun-24 1 Windows Issue::Operating System 16-Jun-24 1 Point of Sale::Reports 15-Jun-24 1 Credit Cards::Batching 15-Jun-24 1 Point of Sale::Close Day 15-Jun-24 1 Windows Issue::Windows Services 16-Jun-24 1 Point of Sale::Balance Drawer/Cashout 15-Jun-24 1 Point of Sale::Printing 15-Jun-24 1 Point of Sale::Order Entry 16-Jun-24 1

Expected Outcome:

1 ACCEPTED SOLUTION
Community Support

First, you can use the following DAX to get the repeated calls every two days:

``````Repeat Count per two day = VAR _selectdate = DAY(SELECTEDVALUE('Table'[Leg - Date]))
RETURN
CALCULATE(COUNTROWS('Table'),FILTER('Table',DAY('Table'[Leg - Date])=_selectdate||DAY('Table'[Leg - Date]=_selectdate+1)))``````

Then you can use the following DAX to get the ratio of repeat calls to total calls and the difference for each month:

``````Divide =
VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date]))
VAR reprtcount = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date]) =_selectmonth&&[Repeat Count per two day]<>1))
VAR countpermonth = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date])=_selectmonth))
RETURN
reprtcount / countpermonth``````
``````Difference = VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date]))
RETURN
[Divide] -  CALCULATE([Divide],FILTER(ALL('Table'),MONTH('Table'[Leg - Date])= _selectmonth-1))``````

Best Regards,

Jayleny

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

Community Support

First, you can use the following DAX to get the repeated calls every two days:

``````Repeat Count per two day = VAR _selectdate = DAY(SELECTEDVALUE('Table'[Leg - Date]))
RETURN
CALCULATE(COUNTROWS('Table'),FILTER('Table',DAY('Table'[Leg - Date])=_selectdate||DAY('Table'[Leg - Date]=_selectdate+1)))``````

Then you can use the following DAX to get the ratio of repeat calls to total calls and the difference for each month:

``````Divide =
VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date]))
VAR reprtcount = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date]) =_selectmonth&&[Repeat Count per two day]<>1))
VAR countpermonth = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),MONTH('Table'[Leg - Date])=_selectmonth))
RETURN
reprtcount / countpermonth``````
``````Difference = VAR _selectmonth = MONTH(SELECTEDVALUE('Table'[Leg - Date]))
RETURN
[Divide] -  CALCULATE([Divide],FILTER(ALL('Table'),MONTH('Table'[Leg - Date])= _selectmonth-1))``````

Best Regards,

Jayleny

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors