Forum Discussion

Sania-F's avatar
Sania-F
Icon for Resolver I rankResolver I
11 months ago

use ISINSCOPE for increased readability in Matrix visual

below measures are used to calculate the sales percentage at an hierarchical level.

measure 1: 
Sales % Group_reg_county =
 DIVIDE(
     SUM(Sales[Sales]),
     CALCULATE(
         SUM(Sales[Sales]),
         REMOVEFILTERS(
             Region[Region],
             Region[Country]
         )
     )
 )
 
 measure 2:
 
Sales % Group_r_c =
 IF(
     ISINSCOPE(Region[Region])
         || ISINSCOPE(Region[Country]),
     DIVIDE(
         SUM(Sales[Sales]),
         CALCULATE(
             SUM(Sales[Sales]),
             REMOVEFILTERS(
                 Region[Region],
                 Region[Country]
             )
         )
     )
 )

Both measures give same results, just the readability is better with ISINSCOPE.

 



3 Replies

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support
    11 months ago

    Hi Sania-F 

    We really appreciate you taking the time to post this! Your explanation of the two approaches is clear and will definitely help others who run into similar use cases. But just for clarity, this space is primarily focused on answering specific questions, while detailed write-ups like yours are best shared on the Fabric Community Blog, where they’ll get even more visibility and engagement.

     

    Regards,
    Microsoft Fabric Community Support Team.