Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tablix SUM of unique values

Hello All,   I have created a Paginated report in Report Builder that contains several value columns and 2 types of rows that are grouped together as below.     The 2 fields at the e...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Adding the rownumber to a new column to count the number of accts under each project name did the trick for me. Once I added the new column to the dataset, in the backend in SQL, since I couldn't figure out in DAX, I was able to get my Sums to work perfectly using the formula below.

     

    =SUM(IIF(Fields!group_row_number.Value = 1, Fields!contract_value_total_amount.Value, 0))

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Adding the rownumber to a new column to count the number of accts under each project name did the trick for me. Once I added the new column to the dataset, in the backend in SQL, since I couldn't figure out in DAX, I was able to get my Sums to work perfectly using the formula below.

 

=SUM(IIF(Fields!group_row_number.Value = 1, Fields!contract_value_total_amount.Value, 0))