DAX Function for COUNTIF and/or CALCULATE

ksobota Not too sure if this would be the right way to go about it without some sample data to work with. There should be a many to one relationship between EMPLOYMENTS and INDIVIDUALS.  As for the DAX formula, maybe something like:

UserIDMatchCount =

CALCULATE
(
    COUNT(EMPLOYMENTS[UserID]),
    EMPLOYMENTS[UserID] =  INDIVIDUAL[UserID]
)

Assuming there is join line on ID field between the 2 tables; have you explored the results of a table visual?  Start a table visual and drag the Employments ID field onto it twice - in the second field change its Values option to Count.

This might give you what you seek.

I have a similiar issue, but this time i want to replicate =COUNTIF($J$2:J2,J2)

So I want the table to count out each of the instances that value is seen.  See below example

Kris 1

Kris 2

Kris 3

John 1

Ed 1

Kris 4

Ed 2

Hi,

I have some list of Purchase documents in a column, and i want to know how many times a purchase order get repeated in the same column. In excel i will use Countif, whereas what will be the best formula to use it in Power Bi.

Eg.

Po Number    Expected Output                   Count if (in Excel)

12345                   3                                       =countif($D$8:$D$17;D8)

23456                   2

35658                   1

12345                   3

12345                   3 

23456                   2

Hi,

I want to ask if on a table with the name Compl and how do you count the number of 100%?

example : 100%

                100%

                100%

                 0%

                 0%

the result is 5 100%,

If in Excel it uses COUNTIF, how about how to do it in power bi?

Thank You

Prajanto

Hi !

I'm a new to PowerBI and I can't find a proper formula to count number of occurance from a filtered value.
I have two tables :

Table A :

-PermissionID (PrimaryKey) with only distinct values

Table B:

-PermissionID (ForeignKey) with non disitinct values

-AreaFrom (blank or not)

I would like to add a calculate column in Table A to count the number of time the AreaFrom is blank for each PermissionID (Table A).

I tried something like that but with no sucess : 

Occurence = 
   COUNTX(
       'public ticket_event_data';
             FILTER(
                'public ticket_event_data';'public ticket_event_data'[area_from_id]=BLANK()
                )
   )

Do you have any suggestions ?

Thanks.

I am having a similar problem. I have a DB view as a dataset. In one column I have the request numbers and in another column I have the CI's associated with the requests. This leaves the same request with multiple CI's. What I need to do is to count the number of requests with the same number to get the number of CI's per request. I have attempted to use the solution that was given here but it won't allow me to use a column as an expression as is listed in the solution. I really have no idea what the issue is here so any help would be appreciated. Here is the DAX that I am attempting to get to work.

Hello
I have this (image) table in excel and would like to obtain the same information in Power BI with DAX, some one have any idea how?, the objective is make it real the chart below.... TNX

Hi, 

I'm new to Power BI. I have been trying to figure if there is a way to use the formula var.p (to calculate variance) in order to calculate variance of approved quantity for each unique item code out of  the 300 unique item codes in total. The items were repeated but I have already grouped them into just the unique values in a new table along with their count values to the no'of time they have occured. All other data remains in the main sheet. Now, I need to figure how to calculate variance of the approved quantities for each item code.

Any suggestions would be much appreciated:)

Thank you