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

MFelix's avatar
MFelix
Super User
8 years ago

Hi aar0n,

 

Not really sure what you mean by you need the actual values itself, unpivoting the columns only change the way the data is saved on the database, you aren't changing any of the values just putting them on columns to use on a different way you can still calculate measures and make visuals based on them you are not makning any data transformation.

 

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