DAX function check status

[Anan]

I want to create a DAX function to find employee count with both On-Premise and On-Clound Source via Status Column.

Please help me. 

[v-yalanwu-msft · Accepted solution]

Hi, @Anan ;

You could create meaure as follows:

count = CALCULATE(DISTINCTCOUNT('Table'[Source]),FILTER(ALLEXCEPT('Table','Table'[EmpID]),([Source]="On Cloud"&&[Status]=1)||([Source]="On Premise"&&[Status]=1)))

both = COUNTROWS(SUMMARIZE(FILTER('Table',[count]=2),[EmpID]))

The final output is shown below:

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

[Ashish_Mathur]

Hi,

Try this

=calculate(distinctcount(data[EmpID]),Data[Source]="On-Premise"||Data[Source]="On-Clound")

Hope this helps.

[Anan]

Thank you, but I would like to check through both On-Premise and On-Cloud Source via Status Column.

how can i do it 😥

[Ashish_Mathur]

Hi,

I do not understand what you mean by "via Status Column"?  Please clarify.

[Anan]

For example, EmpID AGA28 On-Cloud Status equals 0(No) and On-Premise equals 1(Yes)

And I want to count employees who have both On-Premise and On-Cloud Source via Status Column.

[Ashish_Mathur]

Hi,

I assume you want to count Emp ID where Source is On Cloud and On premise and each has a value of 1.  Am i correct?  If yes, then share the link from where i can download your PBI file.