Forum Discussion

jakaihammuda's avatar
jakaihammuda
Icon for Helper III rankHelper III
2 years ago
Solved

Sum Measure outputs into a card visual

Hi,   Im having some issues calculating the sum of row totals, the totals provided are calculated from another measure themselves.    the column i want to calculate the total sum of is this - and...
Need Help
Show and Tell
Tips and Tricks
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, jakaihammuda 

    try below

     

    result =
 sumx(
   filter(
      all('tablename'),
      'tablename'[process column]<>"master" && 'tablename'[process column]<>"validation"

    ),
    [process run time]
  )

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, jakaihammuda 

try below

result =
 sumx(
   filter(
      all('tablename'),
      'tablename'[process column]<>"master"
    ),
    [process run time]
  )
  • jakaihammuda's avatar
    jakaihammuda
    Icon for Helper III rankHelper III
    2 years ago

    Thank you for this! seems to have worked a treat 🙂

    one more questyion, if i want to filter so its not "master" and also not "validation" how would i encorporate this into the DAX?


     

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      hi, jakaihammuda 

      try below

       

      result =
 sumx(
   filter(
      all('tablename'),
      'tablename'[process column]<>"master" && 'tablename'[process column]<>"validation"

    ),
    [process run time]
  )

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • jakaihammuda's avatar
        jakaihammuda
        Icon for Helper III rankHelper III
        2 years ago

        Amazing thank you so much for this 😁