Forum Discussion

pdemontigny's avatar
pdemontigny
Regular Visitor
9 years ago
Solved

Calculated Column: % of Total

I'm trying to recreate an Excel dashboard in Power BI. Part of what I need to do is create a table or matrix (not sure which is best) that shows premium by segment, which I've done. Now I want to cre...
  • parry2k's avatar
    parry2k
    9 years ago

    So you are saying that you don't want slicer to filter out the total data? In that case, you need to create calculated field.

     

    For that you need to create measure, let's say it is called Total Sales,

     

    Total Sales = CALCUALTE(SUM(Sales[Revenue]), ALL(Sales))

     

    % Revenue = SUM(Sales[Revenue])/[Total Sales]

    This is an idea, if you need further help, let me know.

Thiyagu's avatar
Thiyagu
Icon for Helper III rankHelper III
9 years ago

Hi pdemontigny,

 

You can achieve by creating a new calculated column with following formula,

 

Premium Dist = DIVIDE(Question[Enforce Premium],SUM(Question[Enforce Premium])).

 

 Let me know, if you have any queries.