Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure with no Total

Hello, I have a table of measures with projected net, projected gains, and projected totals (net+gains) week to week. Plus an additional measure where I get the following week's projected net.    ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    1.Try to add an additional measure as follows.

    Measure 2 =
    SUMX ( 'Table', [Measure] )

     

    2.You can use SUMMARIZE() to deal with. Below is the similar post for reference:

    Solved: Re: Sum of values in a measure with divide measure - Microsoft Power BI Community

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.