Tableau measure into Power BI

[cham]

Hi,

I want to change tableau measure into Power BI,

Following is the tableau measure,

Clients = SUM(INT([ID] > 8))

I change that it as below in Power BI,

Clients = CALCULATE(SUM(Sheet1[ID]), FILTER(Sheet1[ID]] > 8))

I want to know is this correct?

[mohittimpus · Accepted solution]

Hii @cham, 
This is not correct instead you can use below measure:

Clients = CALCULATE(COUNT(Sheet1[ID ]), Sheet1[ID ]>8)

It will return the same result as Tableau. 

For Example:

ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14

For the above dataset, results are as follow:

In the tableau, result is 6

when you use 

Clients=SUM(INT([ID] > 8))

For Power BI,

you can use below measure for the same result:

Clients = CALCULATE(COUNT(Sheet1[ID ]), Sheet1[ID ]>8)

 It will also return 6 for the above dataset.

If it help, please mark it as Accept as Solution.

Thanks,

mohittimpus

[cham]

Thank you so much