topic Converting Tableau Calculation into Power BI in DAX Commands and Tips

Converting Tableau Calculation into Power BI

Anonymous — Wed, 08 May 2024 13:31:45 GMT

Hi,

I am in the process of converting a load of Tableau dashboards into Power BI but cannot figure out how to translate this particular measure and was hoping someone could point me in the right direction:

Measure from Tableau:
COUNTD([SNO]) / TOTAL(COUNTD([SNO]))

I know COUNTD( ) in tableau is DISTINCTCOUNT( ) in Power BI.
But not able to figure out the total part and also used this calculation

SUMX( ALL(Query1), DISTINCTCOUNT([SNO]) ) by taking reference from the forum. But, it's not working as expected.

Any help would be appreciated

Many Thanks in advance

Re: Converting Tableau Calculation into Power BI

Greg_Deckler — Wed, 08 May 2024 13:33:11 GMT

Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Converting Tableau Calculation into Power BI

Anonymous — Tue, 14 May 2024 07:39:43 GMT

Hi Greg_Deckler ,

This is the data from tableau, I need to replicate the same in power bi, I have attached all the fields and respective data here. Please help me solve this issue.

Thanks.