Forum Discussion

mclaur_and_22's avatar
mclaur_and_22
Frequent Visitor
4 years ago
Solved

Help with DAX for double group count and sum

Hi eveybody,    I'm recently new to PowerBI and its calculated measures and I'm currently having problems with a DAX that I want to create: I have a table with several columns, but the ones I wante...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, mclaur_and_22 

     

    You can try:

    Count = COUNTROWS(filter(SUMMARIZE(Inf_fallas,[REF],[ENLACE],"count",COUNT(Inf_fallas[ENLACE])),[count]>1))

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mclaur_and_22 , Create two measures like

 

cnt = COUNTROWS(Table)

 

countx(filter(Values(Table[Enlace]), [cnt] >1), [Enlace])

mclaur_and_22's avatar
mclaur_and_22
Frequent Visitor
4 years ago

Hi amitchandak, thank you for replying, I have use your formulas and what I get is the total count of costumers that have more than 1 product, instead of the total acount of products (per costumer) that have more than 1 ticket. 

 

As you can see, the measure give me a total sum of 3, which would the number of references that have more than 1 product, according to the table the total sum should be two, because two products of all the products listed presented more than 1 ticket. 

 

Thank you!! 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, mclaur_and_22 

     

    You can try:

    Count = COUNTROWS(filter(SUMMARIZE(Inf_fallas,[REF],[ENLACE],"count",COUNT(Inf_fallas[ENLACE])),[count]>1))

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey