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

I am getting below error when trying to create any measure,

[Anonymous]

Hi everyone, I'm new to power bi. Please help me separate the data from the virtual table into the corresponding tables as follows:

I want to separate the data lines and from the arrow to fill the data before the arrow in the columns in the respective tables, please help me, thanks a lot

[V-lianl-msft]

Hi @gauravnarchal ,

Try to create a condition that is always true:

Measure = IF(NOT(ISBLANK(TABLE[NAME])),10)

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

[themistoklis]

@gauravnarchal 

Have you tried something like 

Measure = 10 

Then add it to the visual.

[gauravnarchal]

Hi @themistoklis  - Yes id did try this measure after which I get the below error.

[themistoklis]

@gauravnarchal 

I dont think it has to do with this particular measure.

Check for other complex measures, do some performance tuning and also check optimise your data model.

You can also check this article:

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/