Forum Discussion

hatahetahmad's avatar
hatahetahmad
Helper I
8 years ago
Solved

Calculated Invoices Count with filtered Measure

Hello,   I have Sales Table contains (Date, ID, Sales Rep, Product, Total)   I Counted the Invoices above 20$ (Used calculate and calculated distinct invoices count)   But My Question when Invo...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi hatahetahmad,

     

    Try this new measure.

    Measure =
SUMX (
    VALUES ( data[Date] ),
    IF ( [Invoices Above 20$] >= 14, [Invoices Above 20$], 0 )
)

    aa

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi hatahetahmad,

 

Try a measure like below. Or you can share a sample.

Measure =
SUMX ( VALUES ( 'table'[sales] ), COUNT ( 'table'[invoice] ) )

Best Regards,

Dale

hatahetahmad's avatar
hatahetahmad
Helper I
8 years ago

I'm afraid that didn't work,

 

Here is sample of my data.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi hatahetahmad,

     

    Try this new measure.

    Measure =
SUMX (
    VALUES ( data[Date] ),
    IF ( [Invoices Above 20$] >= 14, [Invoices Above 20$], 0 )
)

    aa

     

    Best Regards,

    Dale

    • hatahetahmad's avatar
      hatahetahmad
      Helper I
      8 years ago

      Finally, Thank you.