Forum Discussion

luxpbi's avatar
luxpbi
Helper 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
Helper V
8 years ago

Zubair_Muhammad thanks for your answer but it doesn't work even with the [Type] table visual.

And I think that your formula would work only with a table visual with the dimension [Type] and not with others. 

luxpbi's avatar
luxpbi
Helper 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