cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Helper I

## average of sum

Hi, im new in power bi and i fighting with DAX language

hi have calculated a measure with this

A = iferror(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA])/sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI]), blank())

if i list it, by DENOM_ENTE Category , follows the&nbsp; result: BUT I NEED TO CALCULATE avg(A) , and i dont know hot to calculate it

4 REPLIES 4
Community Support

Hi @rufmau68 ,

You want to calculate the average of [A] which is [A]/count of category?

If so you could try the following measure.

``[A]/calculate(distinctcount(category),all(table))``

If not, please show some sample data and expected result to us.

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

@rufmau68 , A seem to Avg Already X/Y

Try Like

Divide(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI]))

Usually, If we want sum till category and avg after that of a measure A, then we will do

Averagex(Value(Table[Category]), [Measure])

Helper I

dont works neither if i wont to match every sum() by denom_ente with grand total

with womthinks like this

grandTotal = calculate(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),all(Calendario[Anno]))

Helper I

i try it but dont works: it return the same value in A column, it seems that it dont overrides category table contest... (*)

(*) i use values() and not value(), because value() need measure column name and not category column name

avgA= Averagex(Values(SCHEDA_CNT_AZIENDA_ENTE[ANNO]), divide(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI])))

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors