Forum Discussion

Boopep's avatar
Boopep
Helper I
10 months ago
Solved

Measure is not working

I want to compute the growth rate between quarters..i group the my months into quarters.... i want to get the growth rate in the total SERIES by Counting them.... comparing them by quarters
 
GROWTH RATE =
VAR SelectedMonths = SELECTEDVALUE('Claims Profile 2025'[REFREC_MONTH (groups)])
VAR CurrentTotal = CALCULATE(COUNT('Claims Profile 2025'[SERIES]), 'Claims Profile 2025'[REFREC_MONTH (groups)] = SelectedMonths)
VAR PreviousTotal = CALCULATE(
    COUNT('Claims Profile 2025'[SERIES]),
    FILTER(ALL('Claims Profile 2025'[REFREC_MONTH (groups)]), 'Claims Profile 2025'[REFREC_MONTH (groups)] = SelectedMonths - 1)
)
RETURN
DIVIDE(CurrentTotal - PreviousTotal, PreviousTotal)
Need Help
  • amitchandak's avatar
    amitchandak
    10 months ago

    Boopep , Qtr and Qtr month comparision should be 3 month behind. Prefer to use a date table joined with date of start/end Date of you data table 

    M1= COUNT('Claims Profile 2025'[SERIES]) 

    M1 Lag 3 = calculate([M1], dateadd(Date[Date], -3, Month) ) 

    If you want to switch between month and qtr, you can use isinscope 

     

    different example, use dateadd in place of offset 

    Previouse Value = SWITCH(TRUE(),
    ISINSCOPE('Date'[Date]), CALCULATE([Net], OFFSET(-1, ALL('Date'[Date]))),
    ISINSCOPE('Date'[Month Year]), CALCULATE([Net],OFFSET(-1, ALL('Date'[Month Year sort],'Date'[Month Year],'Date'[Year],'Date'[Qtr Year]),ORDERBY('Date'[Month Year sort]))),
    ISINSCOPE('Date'[Qtr Year]),CALCULATE([Net], OFFSET(-1, ALL('Date'[Year], 'Date'[Qtr Year]))),
    ISINSCOPE('Date'[Year]), CALCULATE([Net],OFFSET(-1, ALL('Date'[Year])))
    )


    More time intelligence functions 
    https://youtu.be/cyWVzAQF9YU?t=41167

  • V-yubandi-msft's avatar
    V-yubandi-msft
    10 months ago

    Hi Boopep ,

    Thank you for reaching out to the Fabric Community.

    I’ve tested your scenario with sample data, and the logic matches your requirements. I’ve attached a PBIX file showing the setup and expected behavior, please review it and let me know if you need any changes or improvements.
    FYI:

     



    Thank you for your response amitchandak .

    Regards,
    Yugandhar.

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    10 months ago

    Boopep , Qtr and Qtr month comparision should be 3 month behind. Prefer to use a date table joined with date of start/end Date of you data table 

    M1= COUNT('Claims Profile 2025'[SERIES]) 

    M1 Lag 3 = calculate([M1], dateadd(Date[Date], -3, Month) ) 

    If you want to switch between month and qtr, you can use isinscope 

     

    different example, use dateadd in place of offset 

    Previouse Value = SWITCH(TRUE(),
    ISINSCOPE('Date'[Date]), CALCULATE([Net], OFFSET(-1, ALL('Date'[Date]))),
    ISINSCOPE('Date'[Month Year]), CALCULATE([Net],OFFSET(-1, ALL('Date'[Month Year sort],'Date'[Month Year],'Date'[Year],'Date'[Qtr Year]),ORDERBY('Date'[Month Year sort]))),
    ISINSCOPE('Date'[Qtr Year]),CALCULATE([Net], OFFSET(-1, ALL('Date'[Year], 'Date'[Qtr Year]))),
    ISINSCOPE('Date'[Year]), CALCULATE([Net],OFFSET(-1, ALL('Date'[Year])))
    )


    More time intelligence functions 
    https://youtu.be/cyWVzAQF9YU?t=41167

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    Hi Boopep ,

    Thank you for reaching out to the Fabric Community.

    I’ve tested your scenario with sample data, and the logic matches your requirements. I’ve attached a PBIX file showing the setup and expected behavior, please review it and let me know if you need any changes or improvements.
    FYI:

     



    Thank you for your response amitchandak .

    Regards,
    Yugandhar.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    Hi Boopep ,
    Have you been able to look over my response? Please let me know if it meets your needs or if you'd like any changes—I'm happy to update it as needed.

    Thank You.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    Hi Boopep ,
    Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    Hi Boopep ,

    Has your issue been resolved, or do you still need assistance. If you need anything else or more information, please let us know. We're here to help.

     

    Thank you.