sql to DAX

[Anonymous]

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

[Mariusz]

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.

[Anonymous · Accepted solution]

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.

---