Forum Discussion
Post PatronTableau measure into Power BI
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?
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
2 Replies
mohittimpusHelper V
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
chamThank you so much