Forum Discussion
Converting Tableau Calculation into Power BI
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
Any help would be appreciated
Many Thanks in advance
2 Replies
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.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.
