Forum Discussion

riwer's avatar
riwer
Frequent Visitor
1 year ago
Solved

Calculation Groups and Measures

Hi Community! I have a time intelligence calculation group, containing the following items: Current Period = SELECTEDMEASURE() PY = CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('Calendar'[Da...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    A title with SELECTEDVALUE('Calculation group'[Calculation item]) will create an text/number conversion error on YoY and YoY%

     

    Here is a workaround solution ...

     

    1. First create a slicer visual and use the calculated group item as the slicer value.
    2. Then change the slicer visual to a card visual.
    3. Turn off the card label and adjust the card size, font size and background.
    4. Place the card over the title area of original card visuals and group them together.
    5. They will look exactly like one card with a heading, but is actually two that have been cunningly overlaid.

    Please click the [accept solution] and thumbs up buttons. Thank you

speedramps's avatar
speedramps
Super User
1 year ago

A title with SELECTEDVALUE('Calculation group'[Calculation item]) will create an text/number conversion error on YoY and YoY%

 

Here is a workaround solution ...

 

  1. First create a slicer visual and use the calculated group item as the slicer value.
  2. Then change the slicer visual to a card visual.
  3. Turn off the card label and adjust the card size, font size and background.
  4. Place the card over the title area of original card visuals and group them together.
  5. They will look exactly like one card with a heading, but is actually two that have been cunningly overlaid.

Please click the [accept solution] and thumbs up buttons. Thank you

  • riwer's avatar
    riwer
    Frequent Visitor
    1 year ago

    Great workaround, works perfectly for the case!
    Still interested however to understand why a title with SELECTEDVALUE('Calculation group'[Calculation item]) genreates a text/number conversion error on YoY and YoY%

     

    Running into a similar problem with another measure 

    Color main cat = IF(NOT(ISINSCOPE(Account[Sub category])), "Light Gray", "#F5F7F8")

    that is used for conditional formatting in a matrix where the same calculation group is used, for the YoY (and YoY%) calculation items.