Forum Discussion

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago
Solved

Multiple conditions in measure

How can I do multiple conditions in a measure? Right now I have this -  Ship = calculate(count('Table1'[OLI Number]),filter('Table1','Table1'[SD (Flag)]="Y")+0, filter('Table1','Table1'[Status]="Ac...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    Try the following. Only thing I wasn't sure on was what you were trying to do with the +0. Are you trying to remove blanks? I don't think it's needed with a predicate like that.


    Ship =

    CALCULATE (

       COUNTROWS ( 'Table1' )

       'Table1'[SD (Flag)] = "Y",

       'Table1'[Status] = "Active",

       NOT ( ISBLANK ( 'Table1'[OLI Number] ) )

    )

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Ok in that case you don't want to add sepearate calculates.


Instead do it all inside one calculate with a set of filters that return all possible rows including duplicates. Then use DISTINCTCOUNT of your oli column instead of COUNTROWS.

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago

I don't think that will work. There are overlapping filters. They have to be done separately then combined. Separate measures then a combined count of the distinct oli numbers bcdobbs