Working with variable

[Anonymous]

Hello,

I am trying to use variable function for the first time and it does not recognize the table and/or the field.  Does it work, even if the table are not linked.

Here's a copy of the pbix

Regards

https://1drv.ms/u/s!At4hIgQFrUxYjVIYRSj6hBaaqoDV?e=NlbuEO

[Pragati11]

Hi @Anonymous ,

In your pbix file, I can see that you are creating a dax calculation: 

You measure as follows:

Distribution =

VAR

Distribution=Switch(true(),

'Project info'[NBL] && 'Project info'[BudgetRevenu],"Flat","none")

RETURN distribution

A measure requires a summarisation on table columns like SUM, MIN, MAX.

The other thing is in the above measure in one table, you are using column from someother table.

You can only do this when these 2 tables are related to eachother.

Thanks,

Pragati

[parry2k]

@Anonymous, first of all, you are adding a measure and in a measure, you have to use some sort of aggregation to use the column name which you are not doing in your measure.

Now to your original question, what you are trying to achieve? You need to provide a bit more context about your question and what you are trying to achieve. Not necessarily VARiables are always required, it depends on what you are trying to achieve. Putting a question without context is very hard to answer.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak]

@Anonymous , what is variable function ?

[Anonymous]

I mean using a measure such as:

Distribution =

VAR

Distribution=Switch(true(),

'Project info'[NBL] && 'Project info'[BudgetRevenu],"Flat","none")

RETURN distribution

[v-xuding-msft]

Hi @Anonymous ,

Not clear about what you want. You could try this firstly:

Distribution =
VAR Distribution =
    SWITCH (
        TRUE (),
        MAX ( 'Project info'[NBL] ) <> BLANK ()
            && SUM ( 'Project info'[BudgetRevenue] ) <> BLANK (), "Flat",
        "none"
    )
RETURN
    Distribution

There are a few points about your formula:

• As the users above said, measures need to specify an aggreation such as min,max,sum or count etc.. It is not supported to use columns directly.

Distribution =
VAR
Distribution=Switch(true(),
'Project info'[NBL] && 'Project info'[BudgetRevenu],"Flat","none")
RETURN distribution

• They are not boolean type for your columns "NBL" and "BudgetRevenu". So you need to add conditions to get constant values to match the expression.

Distribution =
VAR
Distribution=Switch(true(),
'Project info'[NBL] && 'Project info'[BudgetRevenu],"Flat","none")

RETURN distribution

• The name of variables need to be same as ones while defining.

Distribution =
VAR
Distribution=Switch(true(),
'Project info'[NBL] && 'Project info'[BudgetRevenu],"Flat","none")

RETURN distribution

You could tabke a look at the documents to learn more.

Create measures for data analysis in Power BI Desktop 

SWITCH 

VAR 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Does that make sense? If so, please mark the helpful answer as the solution. More people will benefit from here. If you still have questions, please feel free to ask us.