Forum Discussion

aar0n's avatar
aar0n
Advocate II
8 years ago
Solved

Calculating a sum when a Column header contains a value

Hey guys, i am just wondering if it's possible to create a dax formula that will do a sum, and another that can count the values >0 for any column header that contains the word "Month".      for e...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    8 years ago

    Hi aar0n,

     

    Though that you needed to have it all in your table then you can use a Table visual and just have the totals without hiding the numbers:

     

     

    The measures are calculated in context so it will work the same way.

     

    Regards,

    MFelix

aar0n's avatar
aar0n
Advocate II
8 years ago

I Just mean that in your matrix visual, youre hiding the individual counts and leaving the column sums. 

i only need the total value.

MFelix's avatar
MFelix
Super User
8 years ago

Hi aar0n,

 

Though that you needed to have it all in your table then you can use a Table visual and just have the totals without hiding the numbers:

 

 

The measures are calculated in context so it will work the same way.

 

Regards,

MFelix

  • aar0n's avatar
    aar0n
    Advocate II
    8 years ago

    thanks