Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Invoices Count More than 14 invoices give the number else give me 0
I did If Condition It seems right, but the total giving me the same number as Counted the Invoices above 20$
My tables filterd by Date and Sales Rep Name, I Expect to get the total of invoices that Excedd 20$ per invoice and exceed 14 invoice per working day.
Solved! Go to Solution.
Hi @hatahetahmad,
Try this new measure.
Measure = SUMX ( VALUES ( data[Date] ), IF ( [Invoices Above 20$] >= 14, [Invoices Above 20$], 0 ) )
Best Regards,
Dale
Rather than using an if statement, would it not work if you just use the filter part of the calculate function?
Something like:
calculate(distinctcount('Sales Table'[Sales]),'Sales Table'[Invoice] > 14)
Thank you ThomasDaviesMCR for the reply,
I cant Do that because I made a Mesure that give me invoices Number (each invoice exceed 20$ total)
So, Building in this Measure I want DISTINCTCOUNT of invoices If each day exceed 14 invoices of the 20$
Example:
Day 1 - 20 invoices made (only 12 above 20$) then the measure I want to give me 0 for Day 1
Day 2 - 18 invoices made (only 15 above 20$) then the measure I want to give me 15 for Day 2
Day 3 - 14 invoices made (only 14 above 20$) then the measure I want to give me 14 for Day 3
Hi @hatahetahmad,
Try a measure like below. Or you can share a sample.
Measure = SUMX ( VALUES ( 'table'[sales] ), COUNT ( 'table'[invoice] ) )
Best Regards,
Dale
Hi @hatahetahmad,
Try this new measure.
Measure = SUMX ( VALUES ( data[Date] ), IF ( [Invoices Above 20$] >= 14, [Invoices Above 20$], 0 ) )
Best Regards,
Dale
Finally, Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |