Forum Discussion

BishwaR's avatar
BishwaR
Helper V
5 years ago
Solved

SQL logic in DAX

I have a SQL logic count ( distinct(PurchaseOrder) | |SubOrder. How to translate it in DAX, I tried as CALCULATE( COUNT(SubOrder),DISCTINCTCOUNT(PurchaseOrder) But I dId not get the correct resutl ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi BishwaR ,

    Just use Count() directly to create measure:

    Count Suborders = COUNT('Table'[Suborder])

    Attached the sample file in the below, hopes it could help.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BishwaR's avatar
BishwaR
Helper V
5 years ago

Each Purchase Order has sub orders.

If PO 12 has three Suborders

   PO 22 has one Suborder

   PO 33 has four suborder

then I am trying to show in the report 

PO 12 has 3 suborders

PO 22 has 1 suborders

PO 33 has 4 suborder

TOTAL suborders 8

 

Thank you

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi BishwaR ,

Just use Count() directly to create measure:

Count Suborders = COUNT('Table'[Suborder])

Attached the sample file in the below, hopes it could help.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.