Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AMorulita
New Member

Convert Tableau calculations into PowerBi dax

Hi friends! Please help!

I'm new to PowerBI and I need to convert a couple of calculation from Tableau into PowerBI:

  1. I need to calculate the total number of fields that were marked with an error for a specific user.
  2. I need to calculate the total number of fields reviewed for a specific user.
  3. I need to calculate the above two but cross all users.
  4. I need to visualize top 4 fields with errors across all users.

Context: users work/update fields. The reviewers check those worked fields and mark with Error or No Error. We need to calculate the defect ratio between the fields marked with errors versus total fields reviewed for each user. Also, need to calculate the defect ratio overall across all users.

Thanks so much for all your help!!!!

In Tableau the calculations look like:

Defect ratio: 1-(SUM([No Error Count])/SUM([All Field Count]))

No Error Count: {FIXED [User],[ReviewDate], [ErrorType], [ReviewItemID]:SUM(IF [ErrorType]="No Error" THEN 0 Else 1 END)}

All Field Count: {FIXED [User],[ReviewDate], [ReviewItemID]:COUNT([ErrorType])}

I tried putting dax together but didn't get any meaningful results.

 

Sample data looks like the 3rd table below. So, for example, then I would calculate the Correctness indicator for June, which is =(100-(7*100/28))/100 (Incorrect Info errors=7, all reviewed fields=28). I would also calculate the Completeness indicator for June, which is =(100-(5*100/28))/100 (Missing errors=5, all reviewed fields=28). 

Top 4 fields with errors across all users: 

Document Content6
Document Remarks7
Document Title8
Document Translation7

 

UserAssessment ScoreCalculation explanation
User 155.56%

=(100-(4*100/9))/100

User 250.00%

=(100-(5*100/10))/100

User 366.67%

=(100-(3*100/9))/100

 

UserItemIDFieldErrorTypeStatusReview Date
 User 112345Document TitleIncorrect InformationCorrection NeededJun-24
 12345Document ContentNo ErrorNo Correction NeededJun-24
 12345Document TranslationNo ErrorNo Correction NeededJun-24
 12345Document RemarksNo ErrorNo Correction NeededJun-24
User 1123456Document TitleMissingCorrection NeededJun-24
 123456Document TitleIncorrect InformationCorrection Needed
 123456Document ContentMissingCorrection NeededJun-24
 123456Document TranslationNo ErrorNo Correction NeededJun-24
 123456Document RemarksNo ErrorNo Correction NeededJun-24
User 267890Document TitleNo ErrorNo Correction NeededJun-24
 67890Document ContentNo ErrorNo Correction NeededJun-24
 67890Document TranslationIncorrect InformationCorrection NeededJun-24
 67890Document RemarksMissingCorrection NeededJun-24
 67890Document RemarksIncorrect InformationCorrection NeededJun-24
User 29876Document TitleIncorrect InformationCorrection NeededJun-24
 9876Document TitleMissingCorrection NeededJun-24
 9876Document ContentNo ErrorNo Correction NeededJun-24
 9876Document TranslationNo ErrorNo Correction NeededJun-24
 9876Document RemarksNo ErrorNo Correction NeededJun-24
User 31234567Document TitleIncorrect InformationCorrection NeededJun-24
 1234567Document ContentNo ErrorNo Correction NeededJun-24
 1234567Document TranslationMissingCorrection NeededJun-24
 1234567Document TranslationIncorrect InformationCorrection NeededJun-24
 1234567Document RemarksNo ErrorNo Correction NeededJun-24
User 3654321Document TitleNo ErrorNo Correction NeededJun-24
 654321Document ContentNo ErrorNo Correction NeededJun-24
 654321Document TranslationNo ErrorNo Correction NeededJun-24
 654321Document RemarksNo ErrorNo Correction NeededJun-24
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@AMorulita First, I would use the Fill down feature in Power Query to fill out your User column. Then you can do things like this:

Measure 1 = 
  VAR __Table = SUMMARIZE( FILTER( 'Table', [ErrorType] <> "No Error" && [User] = "User 1" ), [ItemID], [Field] )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

Measure 2 = COUNTROWS( FILTER( 'Table', [User] = "User 1" ) )

Measure 3a = 
  VAR __Table = SUMMARIZE( FILTER( 'Table', [ErrorType] <> "No Error" ), [ItemID], [Field] )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

Measure 3a = COUNTROWS( 'Table' )

For the last one you can use a TopN filter or TOPN DAX function or perhaps RANKX


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@AMorulita First, I would use the Fill down feature in Power Query to fill out your User column. Then you can do things like this:

Measure 1 = 
  VAR __Table = SUMMARIZE( FILTER( 'Table', [ErrorType] <> "No Error" && [User] = "User 1" ), [ItemID], [Field] )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

Measure 2 = COUNTROWS( FILTER( 'Table', [User] = "User 1" ) )

Measure 3a = 
  VAR __Table = SUMMARIZE( FILTER( 'Table', [ErrorType] <> "No Error" ), [ItemID], [Field] )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

Measure 3a = COUNTROWS( 'Table' )

For the last one you can use a TopN filter or TOPN DAX function or perhaps RANKX


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors