Forum Discussion

eyesem's avatar
eyesem
Helper I
5 years ago
Solved

Total by group at row level

Hi   I need to get a measure 'Qcartera' as the sum of all the QA values for each distinct NISS in the filtered view of the table (in this example the applied filters are narrowing down the table to...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    eyesem try this measure, now I understood your model better:

     

    Measure = 
CALCULATE(
    SUMX ( 
        VALUES ( 'Dimension'[CODE] ),
        CALCULATE (MAX ( 'Fact'[QA] ) )
    ),
    FILTER (
        ALLSELECTED ('Fact' ), 
        COUNT ('Fact'[INDEX] ) >=1 
    )
)

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

eyesem try this measure

 

Measure = CALCULATE ( SUMX ( ALL ( Data[QA], Data[NISS] ) , CALCULATE ( MAX ( Data[QA] ) ) ), ALL () )

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • eyesem's avatar
    eyesem
    Helper I
    5 years ago

    Thank you for your reply.

    This doesn't seem to be working either. It is creating duplicated rows and the measure seems to be adding all the rows, not only the two in the table: