Forum Discussion

masplin's avatar
masplin
Impactful Individual
1 month ago
Solved

ISINSCOPE and missing totals

Have tried lots of different ideas and cant get anything to work I am plotting care home providers against geograhpic demographics so the providers are not part of the geographic hierachy.    I ...
  • v-achippa's avatar
    v-achippa
    1 month ago

    Hi masplin,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Here the issue is that the grand total is also evaluated against the filter condition. At the total level the measure returns the overall average (2.6), which is outside your selected range (4-4.5), so the measure returns blank.

    To resolve this, handle the grand total separately instead of applying the same IF logic used for individual LA rows. Recalculate the total using only the LA’s that meet the selected rank range and the same approach applies to the No Sites measure also.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 month ago

Hi masplin,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Here the issue is that the grand total is also evaluated against the filter condition. At the total level the measure returns the overall average (2.6), which is outside your selected range (4-4.5), so the measure returns blank.

To resolve this, handle the grand total separately instead of applying the same IF logic used for individual LA rows. Recalculate the total using only the LA’s that meet the selected rank range and the same approach applies to the No Sites measure also.

 

Thanks and regards,

Anjan Kumar Chippa