Forum Discussion
Convert Tableau function into Power BI Dax
sum(if [AUDITOR]<>[Auditor Filter] then [NC] else 0 end ) / sum(if [AUDITOR]<>[Auditor Filter] then [APPEAR] else 0 end ) here AUDITOR = Auditor filter, and Auditor filter is used as Parameter . ...
Anonymous , a new measure
Divide(
sumX(Table, if( [AUDITOR]<>[Auditor Filter] ,[NC] ,0 ) ) , sumX(Table,if( [AUDITOR]<>[Auditor Filter] ,[APPEAR] , 0 )))