undefined

[Anonymous]

I am not getting sum of score of the subcategories at the team level.The measure is checking the condition at members and also at team level !!!!!

How to get sum of 170& 100 i.e270 for sparkling white. 

Dress_test =

var x = calculate(count(table5[member_Id]),Table5[Attendance]<>"A" && Table5[Meeting_Date]>=min(Table2[Start_Date]) && Table5[Meeting_Date]<min(Table2[End_Date])&& Table5[Dress_Code]=20)

var y = calculate(count(table5[member_Id]), Table5[Meeting_Date]>=min(Table2[Start_Date]) && Table5[Meeting_Date]<min(Table2[End_Date])) 

return

CALCULATE(if(x=y && x <> BLANK(),sum(Table5[Dress_Code])+50,sum(Table5[Dress_Code])))

19 and 16 are  dates.

[Anonymous]

@Mikelytics  but it doesn't solve my  problem. The value for sparkling white is still coming 220.

[Mikelytics]

Please try the follwowing.

Creat a new measure on top:

measure on top =

SUMX(
   VALUES(Table5[Dress_Code]),
   CALCULATE([Dress_test])
)

now use this measure in your table.

to be able to help you more we need more information about the data model behind.

what are the tables and what is the granularity?

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

[Mikelytics]

HI,

after putting your table in the dax formatter I identified some missing spaces and wrong placed brackets.

I also took away the CALCUALTE after thre RETURN since it does not bring any value.

Please try

Dress_test =
VAR x =
    CALCULATE (
        COUNT ( table5[member_Id] ),
        Table5[Attendance] <> "A"
            && Table5[Meeting_Date] >= MIN ( Table2[Start_Date] )
            && Table5[Meeting_Date] < MIN ( Table2[End_Date] )
            && Table5[Dress_Code] = 20
    )
VAR y =
    CALCULATE (
        COUNT ( table5[member_Id] ),
        Table5[Meeting_Date] >= MIN ( Table2[Start_Date] )
            && Table5[Meeting_Date] < MIN ( Table2[End_Date] )
    )
RETURN
    IF (
        x = y
            && x <> BLANK (),
        SUM ( Table5[Dress_Code] ) + 50,
        SUM ( Table5[Dress_Code] )
    )

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.