Forum Discussion
UditJ
Helper III
3 years agoTo convert Tableau Calculation to Power BI DAX
How to write below calculations from tableau in DAX:- 1. COUNT(IF[is DQ] =1 AND [Resolved] =0 THEN 1 END) 2. [Placements with Open Errors] / MAX({FIXED [User]:COUNTD([Pcode])}) 3. IIF([Sho...
Mahesh0016
Super User
3 years agoUditJ I hope this help's you!
1. COUNT(IF[is DQ] =1 AND [Resolved] =0 THEN 1 END)
CNT =
VAR X = IF(AND([is DQ] =1,[Resolved] =0),1)
RETURN
COUNTX('Table Name',X)
#############################################################
2. [Placements with Open Errors] / MAX({FIXED [User]:COUNTD([Pcode])})
DvD = DIVIDE([Placements with Open Errors] ,MAX({FIXED [User]:COUNTD([Pcode])}))
If this not work Please explain MAX({FIXED [User]:COUNTD([Pcode])}) formula.
#############################################################
3. IIF([Show Ignored Errors]="True",[Ignored Errors],NULL)
IIFS = IF([Show Ignored Errors]="True",[Ignored Errors],NULL)
UditJ THANK YOU!!