Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sql to DAX

Hi, I have the sql to get to what I need, however, I need to have the DAX for it. Can you help please? select field1, count(field2) AS myvalue from Table1 where field8 > 0 group by field1   Th...
  • Anonymous's avatar
    Anonymous
    7 years ago

    basically I would like to get to this sql in DAX

    select field1, count(distinct field2) AS myvalue from Table1
    where field8 > 0
    group by field1

     

    Can you help please/

    Thank you

    Mariusz wrote:

    Hi Anonymous 

     

    I think it will be something like below, but it would be easier if you provide a sample data and the desired outcome.

    Measure = 
CALCULATE( 
    DIVIDE( 
        COUNT( Table1[R_Key] ), 
        DISTINCTCOUNT( Table1[P_Key] ) 
    ),
    Table1[sales] > 0
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

I think it will be something like below, but it would be easier if you provide a sample data and the desired outcome.

Measure = 
CALCULATE( 
    DIVIDE( 
        COUNT( Table1[R_Key] ), 
        DISTINCTCOUNT( Table1[P_Key] ) 
    ),
    Table1[sales] > 0
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    basically I would like to get to this sql in DAX

    select field1, count(distinct field2) AS myvalue from Table1
    where field8 > 0
    group by field1

     

    Can you help please/

    Thank you

    Mariusz wrote:

    Hi Anonymous 

     

    I think it will be something like below, but it would be easier if you provide a sample data and the desired outcome.

    Measure = 
CALCULATE( 
    DIVIDE( 
        COUNT( Table1[R_Key] ), 
        DISTINCTCOUNT( Table1[P_Key] ) 
    ),
    Table1[sales] > 0
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski