cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III

Hi,

I have a database like this:

 a b c d e sara 1 2 6 7 chiara 5 6 7 6 ambra 8 3 2 3

I have this measure:

Measure = sum(Foglio1[b])+ sum(Foglio1[c])+ sum(Foglio1[d]) + sum(Foglio1[e])

I have a table and a gauge like this:
I need to have the average of measure (18,6) instead of sum in both gauge and total in the table
How can I do?
Thanks
1 ACCEPTED SOLUTION
Super User

Try

``````My measure =
IF (
ISINSCOPE ( 'Foglio1'[a] ),
SUMX ( 'Foglio1', 'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e] ),
AVERAGEX (
'Foglio1',
'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e]
)
)
``````
2 REPLIES 2
Super User

Try

``````My measure =
IF (
ISINSCOPE ( 'Foglio1'[a] ),
SUMX ( 'Foglio1', 'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e] ),
AVERAGEX (
'Foglio1',
'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e]
)
)
``````
Helper III

thanks!

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors