Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a measure from a variable table

Good afternoon,   I am not able to complete one of my needed measures.    My direct query table contains this structure: users steps 1 NEW 1 NEW 1 NEW 2 OLD 2 OLD 3 O...
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    Count the number of rows where "nº values" is three or greater.

     

    COUNTROWS ( FILTER ( tabla, [nº values] >= 3 ) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please try the below for creating a new table.

 

 

VAR Tables =
ADDCOLUMNS (
VALUES ( 'Table'[users] ),
"@values",
CALCULATE ( DISTINCTCOUNT ( 'Table'[users] ), 'Table'[steps] = "NEW" ) + 0
)

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your quick answer Jihwan.

     

    The thing here is that I didn´t want to create a new table, just a variable table.

     

    Thank you anyways 🙂