Forum Discussion

mariuscourcel's avatar
mariuscourcel
Frequent Visitor
6 years ago
Solved

Return a unique value by counting specific values under multiple criterias

Hello all,   I am trying to return a unique number (this is important, because i know how to get that number through a table visual, but not as a single value) based on specific criterias : i need ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi mariuscourcel ,

     

    Do you mean to get the "Test" formula? Try to add "Date" condition.

    Test =
IF (
    COUNTROWS (
        FILTER (
            Bd_03_Franco;
            Bd_03_Franco[Cle_Liv] = EARLIER ( Bd_03_Franco[Cle_Liv] )
                && Bd_03_Franco[Date] = EARLIER ( Bd_03_Franco[Date] )
        )
    ) > 1;
    1;
    BLANK ()
)

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi mariuscourcel ,

 

Do you mean to get the "Test" formula? Try to add "Date" condition.

Test =
IF (
    COUNTROWS (
        FILTER (
            Bd_03_Franco;
            Bd_03_Franco[Cle_Liv] = EARLIER ( Bd_03_Franco[Cle_Liv] )
                && Bd_03_Franco[Date] = EARLIER ( Bd_03_Franco[Date] )
        )
    ) > 1;
    1;
    BLANK ()
)

 

mariuscourcel's avatar
mariuscourcel
Frequent Visitor
6 years ago

Hi v-eachen-msft 

 

Yes, that's the idea.

 

It does work for my problem, although this might not be the best way to do it. If you have any other way, just has a way of learning more, please do share.

 

I will accept this as answer.

 

Thank you !