Add Static value Column - Measure

[gauravnarchal]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[amitchandak]

@gauravnarchal , create a new measure

measure=10

[gauravnarchal]

@amitchandak  - I am getting the below error when I am trying to add this measure.

[gauravnarchal]

@amitchandak  - This measure is not working 😞 any other way I can do it?