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

 

Thank you

  • 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

     

     

2 Replies

  • 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