Forum Discussion

anandsingh04198's avatar
anandsingh04198
New Member
8 years ago

Need the Grand total

Hi All

 

I have to create a new measure which will show the %age based on one column. And for that i need grand total of that column. I have snow flake schema and i am pulling the table directly from SQL Server. In my current model, everything is related to Patient. 

In the attachment i need a different measure which shows the grand total of highlighted column and then i can use that measure as to caluclate the &age. Remember i can use any other attribute insted of biomarker and grand total should show the correct total so that %age comes correctly at all the levels.

factor is coming from below attached table and this factor will caclulate at all the levels.

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi anandsingh04198,

     

    Can you share a dummy sample, please?

    Is it the below ones that can give you the total?

    Measure = sum('table'[factor])

Measure = calculate(sum('table'[factor]), all('table'))

    What are the levels?

     

    Best Regards,

    Dale