Forum Discussion

Maahmohammed's avatar
Maahmohammed
Helper I
1 year ago
Solved

Measure & Calculated filed

Dears, I have the below table & I'd like to have a measure & a calculated column code to get the count of invoices  / Customers / Day Appreciating your support. Invoice No. Date Item Custome...
Need Help
  • Shravan133's avatar
    Shravan133
    1 year ago

    Try this:

    CountInvoicesColumn =
    CALCULATE(
    DISTINCTCOUNT('Table'[Invoice No.]),
    ALLEXCEPT('Table', 'Table'[Date], 'Table'[Customer ID])
    )

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi Maahmohammed ,
    You can create a measure to calculate DISTINCT invoices by this DAX:

    InvoiceCountMeasure = 
CALCULATE(
    DISTINCTCOUNT('YourTable'[Invoice No.]),
    ALLEXCEPT('YourTable', 'YourTable'[Customer ID], 'YourTable'[Date])
)

     

    You result will look like this:

     

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi Maahmohammed ,
You can create a measure to calculate DISTINCT invoices by this DAX:

InvoiceCountMeasure = 
CALCULATE(
    DISTINCTCOUNT('YourTable'[Invoice No.]),
    ALLEXCEPT('YourTable', 'YourTable'[Customer ID], 'YourTable'[Date])
)

 

You result will look like this: