I am pulling the Average Cost and Average Invoice Charge for a part. My next column is how many times it occurred, which is 88 times. I now need a column that tells me how many times the Invoice Charge was above the average. How can I do this?
Depends on your data model.
If you have a table of Products with Average Invoice Charge and another table with your Invoices, then you could link the two tables on something like Product ID and then add a calculated column or measure like:
AboveAverage = CALCULATE(COUNTROWS(RELATEDTABLE(Invoices)),Invoices[InvoiceCharge]>Products[AverageInvoiceCharge]),
Something like that.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Depends on your data model.
If you have a table of Products with Average Invoice Charge and another table with your Invoices, then you could link the two tables on something like Product ID and then add a calculated column or measure like:
AboveAverage = CALCULATE(COUNTROWS(RELATEDTABLE(Invoices)),Invoices[InvoiceCharge]>Products[AverageInvoiceCharge]),
Something like that.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
