Forum Discussion

mmqqq19999's avatar
mmqqq19999
Regular Visitor
2 years ago

Bug: Base64 Text Measures break down when having Calculation Groups

Hi all. I have a few concatenate measures to bypass the 32000-character limit in Power BI - They all work fine until I add a calculation group and calculation item - they all break down then. You don't even have to use it - the mere existence of a calculation item is enough to break them. I cannot find much info on the web about this very niche issue. Hopefully, someone has an answer/explanation. 

Cheers,

Quang

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    9 hours ago
    Calculation Group = IF( ISSELECTEDMEASURE([Base64MeasureName]),       SELECTEDMEASURE(),      You Calculation group code)

    Hi mmqqq19999​ ,

    You refer that the mere existence of a calculation item breaks the item, when you refer this is to have a slicer on the page were you are using the measures or in any page.

    Can you try to have an exception in the Calculation group something similar to this.

    Be aware that you can use more than one measure inside the ISSELECTEDMEASURE. This code will force the specified measure to be calculated normally.