Forum Discussion
Post ProdigyAdd 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 | LON | 10 |
| ABC Intl | CAI | 10 |
| ZZZ Logistics | MEL | 10 |
| ABC Intl | DEL | 10 |
| ABC Intl | SHA | 10 |
| ABC Intl | NYC | 10 |
| ZZZ Logistics | NYC | 10 |
7 Replies
- amitchandak
Super User
gauravnarchal , create a new measure
measure=10
gauravnarchalamitchandak - This measure is not working 😞 any other way I can do it?
- gauravnarchal
Hi gauravnarchal ,
You can create a measure as below:
Measure = CALCULATE ( 10, ALLSELECTED ( 'Table' ) )Best Regards
- gauravnarchal
Anonymous - I am getting below error when I try to enter this measure.
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
Hi gauravnarchal ，
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
