Forum Discussion
To 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([Show Ignored Errors]="True",[Ignored Errors],NULL)
Amy suggestions ?
1 Reply
- Mahesh0016
Super User
UditJ 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!!