cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors