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

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.