Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Get a sum without the visuals filters

Hi I have a visual as shown in the picture below. The rows are a buildings "energy grade" which is a letter from A to E and below are the buildings in thos categories. The measure "Sum utleieareal N...
Need Help
v-jialluo-msft's avatar
v-jialluo-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi  Anonymous ,

 

With your description, you need to sum up some specific data.

This requires you to provide sample data and expected output. You can try it first:

Test Sum utleieareal NY = CALCULATE（SUM（'Sertifiseringer alle bygg'[Fordeling areal energimerke]）， ALLEXCEPT（Energiklassifisering[Karakter]））

 

Best Regards,
Gallen Luo

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi
    This does not work. I get the same output as in picture 1. Same as the formula Sum utleieareal NY = SUM('Sertifiseringer alle bygg'[Fordeling areal energimerke]).