Using If Command

[jimmerph]

I have created a table in power bi and im trying to display how many files are allocated to different people

i have created a new column for the table and used

the below returns the amount of files in that name. I am now trying to add another name to this but am unable to work out how this is done without error messaages appearing

Any help would be much appreciated

Total Files = If(sql view name[column name] = "Joe Bloggs",1,0)

[v-juanli-msft]

Hi @jimmerph 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[amitchandak]

@jimmerph , if you are working in power query/M

try

Total Files = If 'sql view name'[column name] = "Joe Bloggs" then 1 else 0

in dax

Total Files = If('sql view name'[column name] = "Joe Bloggs",1,0)

Table name with space can not come like this, select it from the list in the formula box

[Fowmy]

@jimmerph 

Can you share the screenshot of the error message?
It is not clear what exactly you are trying to do and the issue you are facing.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[jimmerph]

bad copy paste job on my part

Total Files = If(sql view name[column name] = "Joe Bloggs",1,0)

if i wanted to find the files of jane doe depending on how i add this depends on the error, i have tried many different ways even using switch and cant seem to get the total files or jane doe to show along with joe bloggs.

the table i am trying to display as

Name of Person           Number of files

joe bloggs                            145
jane doe                               140

[v-juanli-msft]

Hi @jimmerph 

Create a measure(Modeling menu-.New measure),

measure=calculate(DISTINCTCOUNT(table[file id]),allexcept(table, table[Name of person]))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

@jimmerph - you haven't clarified what you are trying to do. This is the Power Query forum, and to do an if/then/else in Power Query, you use the following syntax:

 if [column name] = "Joe Bloggs" then 1 else 0

the if/then/else must be lower case.

If you are in DAX, then it depends. If you are doing a measure, your formula will not work. This might:

 If(MAX('sql view name'[column name]) = "Joe Bloggs",1,0)

I say "might" because it depends on the filter context of the visual.

If it is in a calculated column, then you use this:

 If([column name] = "Joe Bloggs",1,0)

You don't need the table in a calculated column as you cannot reference other tables without using the RELATED() function, and you aren't doing that.

If that isn't what you need, please tell us exactly  how you are trying to do this.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum