Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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 )
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |