Level of Detail Calcs to DAX

[mjain9]

Hello 

I am currenctly trying to get diffrent reports from Tableau to DAX. I am really a beginner at DAX but can someone explain what the formula below in Tableau does and help me convert it to PowerBI DAX. 

 This is what i have in LOD  ; 

IF ATTR([Branch]) = 'Specialist' THEN

SUM({ FIXED [Branch], [Manager],[Product Group],[Scorecard Category Type]: AVG([Manager Revenue Goal])})

ELSE

SUM({ FIXED [Branch], [Manager],[Region], [Product Group],[Scorecard Category Type], [Segment]: AVG([Manager Revenue Goal])})

END

And the Dax I wrote : 

CALCULATE(AVERAGEx(FILTER(score, score[Manager Revenue Goal] <> BLANK()), score[Manager Revenue Goal]), ALLEXCEPT(score, score[Branch], score[Manager], score[Region], score[Product Group], score[Scorecard Category Type], score[Segment]))

Unfortunately, My final results are not matching. Can somebody help me with it ? What I am doing wrong ? 

thanks

[v-yulgu-msft]

Hi @mjain9,

As I am not familiar with LOD used in Tableau, I don't understand what above LOD code can achieve. Please post sample data and just show your desired output, if possible, describe the calculation rule detailedly, so that I can test and try to achieve the requirement with DAX.

Regards,

Yuliana Gu