Forum Discussion

eaj's avatar
eaj
Icon for Helper I rankHelper I
3 years ago
Solved

Count occurence per ID and per type

In my dataset I have some products that consists of a base fee and then the custommer pays extra per extra item.  The invoice data are available in a table as follow: #Invoice Main_Item Ba...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    eaj 

    pls try this

    Measure = CALCULATE(DISTINCTCOUNT('Table'[#Invoice]),FILTER('Table','Table'[Base_fee_included]="No"))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

eaj 

pls try this

Measure = CALCULATE(DISTINCTCOUNT('Table'[#Invoice]),FILTER('Table','Table'[Base_fee_included]="No"))