Forum Discussion

Picco's avatar
Picco
Frequent Visitor
1 year ago
Solved

Calculation Group and SelectedValue

Good day   I have 4 Calculation Items in my Calculation Group   MTD = CALCULATE(SELECTEDMEASURE(), DATESMTD('Date'[ADate]) ) MTD PY =  CALCULATE( SELECTEDMEASURE(), DATEADD(DATESMTD('Date'[ADate...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    Calculation group logic is only applied once per measure, so statements like

    VAR _Value = CALCULATE( SELECTEDMEASURE(), CG_TimeIntelligence[Name] = "MTD PY" )

    won't work.

    What you could do is to create a separate calculation group for labels, which would then be able to call the time intelligence calculation items. You could have the calculation item return a numeric value for the variance, which you would then be able to detect in conditional formatting, and use the format string property of the label calculation item to return the formatted string using the exact code you already have in the Label calculation item you posted.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi Picco,

Thank you for using Microsoft Fabric Community Forum.
 

I wanted to check if you had the opportunity to review the information provided by johnt75 . Please feel free to contact us if you have any further questions.

Thank you.

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi Picco,

     

    We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

    If you need any further assistance, feel free to reach out.

     

    Thank you for being a valued member of the Microsoft Fabric Community Forum!

    • v-sgandrathi's avatar
      v-sgandrathi
      Community Support
      1 year ago

      Hi Picco,

       

      As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

      Thank you.