topic Re: Table Total in DAX Commands and Tips

Table Total

colintemlett — Tue, 27 Sep 2022 12:47:06 GMT

Is it possible to do a specific callcualtion for a row/colum total

Per below i need the total NBCP value to being the Total RFS/Total NWB = 435 and not the sum of that column??

Help will be highly appreciated

Re: Table Total

PabloDeheza — Tue, 27 Sep 2022 13:02:48 GMT

Hi there!

You can try:

Measure = IF( HASONEVALUE( YourCategory ), CurrentCalculation, Total RFS/Total NWB )

Let me know if that helps!

Re: Table Total

colintemlett — Wed, 28 Sep 2022 09:47:44 GMT

Sorry a little confused with the below..what would I add to category…and I cant seem to add in a formula at te end..do i need to do a measure for the total RFS and total NWB

Measure = IF( HASONEVALUE( YourCategory ), [NBCP per RFS] , Total RFS/Total NWB )

Re: Table Total

PabloDeheza — Wed, 28 Sep 2022 13:01:01 GMT

Hi!

CAB would be you "Category", I assume CAB stands for "Cabinet" which you already added, so it looks good.

For Total RFS/Total NWB you need to either create a measure that returns the value you want in the total, or apply the calulation right there.

Re: Table Total

colintemlett — Thu, 29 Sep 2022 11:30:34 GMT

Hi Pablo

Need some help on a formula...

What formula would i use if i wanted to total a column value if it includes a specific word in anothe column?

If there is a word in column X c that is CONT sum the total colum for only those rows that have that word in the colum X?

Re: Table Total

PabloDeheza — Thu, 29 Sep 2022 12:23:49 GMT

Hey!

That would be something like this:

CALCULATE( SUM( YourColumnToSum), ColumnwithText = "YourWord" )

Let me know if that helps!