Forum Discussion

luxpbi's avatar
luxpbi
Icon for Helper V rankHelper V
8 years ago

Problem with total row in matrix

Hi all,    I have a Data that looks similar to this: Type Amount Number Average Price A           1.000                   10                      100   B           2.000          ...
Need Help
luxpbi's avatar
luxpbi
Icon for Helper V rankHelper V
8 years ago

Anyone wit more ideas? It's really urgent for me. 
If I don't find a solution I'll have to do a lot of different meassures, one for each dimension. And it's not efficient at all...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI luxpbi,

 

Maybe you can try to use row count as calculate condition :

 

Number =
IF (
    COUNTROWS(Table)=1,
    DIVIDE ( [Amount], [Average Price], BLANK () ),
    SUMX (
        ALLSELECTED ( Table ),
        DIVIDE ( [Amount], [Average Price], BLANK () )
    )
)

 

 

Regards,

Xiaoxin Sheng