Forum Discussion

RubenMerino's avatar
RubenMerino
Frequent Visitor
3 years ago
Solved

Distinc count grup by specific column

Hi   I have a table with columns: ID, Order sale and Product.   I need a mesure than count the number of Order sale that have iqual or more than 2 product. The photo of down resum the idea bet...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try this measure:

     

    Measure = var flag = CALCULATE(COUNT('Table'[Order Sale]))>=2
    return
    if(flag=TRUE(),CALCULATE(DISTINCTCOUNT('Table'[ID])),0)
     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

try this measure:

 

Measure = var flag = CALCULATE(COUNT('Table'[Order Sale]))>=2
return
if(flag=TRUE(),CALCULATE(DISTINCTCOUNT('Table'[ID])),0)
 

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍