Forum Discussion

mohit19's avatar
mohit19
Frequent Visitor
8 years ago

DAX Result

I have attach a screenshot of my table view :http://prntscr.com/jx6ow8 I have created a measure : Measure 6 = CALCULATE(COUNT(TblStudent[StId]),TblStudent[StStatus]="Active"), which give count of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI mohit19,

 

You can try this, I add condition to skip replace formula calculate on total level:

StudentCount =
IF (
    CALCULATE ( COUNT ( TblStudent[StId] ), TblStudent[StStatus] = "Active" )
        > 20
        && ISFILTERED ( TblStudent[StId] ),
    20,
    CALCULATE ( COUNT ( TblStudent[StId] ), TblStudent[StStatus] = "Active" )
)

Regards,

Xiaoxin Sheng