Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
5 years ago

Add Static value Column - Measure

Hello - How can I create a measure to show 10 value in each row of a table or matrix?   Name Branch (Measure) Add column and show 10 value in each row ABC Intl NYC 10 ZZZ Logistics LO...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi gauravnarchal ,

You can create a measure as below:

 

Measure = CALCULATE ( 10, ALLSELECTED ( 'Table' ) )

 

Best Regards

  • gauravnarchal's avatar
    gauravnarchal
    Post Prodigy
    5 years ago

    Anonymous - I am getting below error when I try to enter this measure.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi gauravnarchal ,

      According to this official documentation, it is due to the visual has attempted to query too much data for us to complete the result with the available resources. It is recommended to filter the visual to reduce the amount of data in the result. You can adopt the method in the following link to resolve the problem.

      The “Visual Has Exceeded The Available Resources” Error In Power BI

      Or please update the formula of measure as below and check whether it still get any error.

      Measure = CALCULATE ( 10, ALLSELECTED ( 'Table'[Name], 'Table'[Branch] ) )

      Best Regards