Forum Discussion

deboec's avatar
deboec
Icon for Helper I rankHelper I
5 years ago
Solved

Measure for Average displayed in Card Visual

Hello guys,   I am displaying a Matrix visual in Power BI that shows me a specific value for business units.   Business Unit Cost 1 1,000 2 2,000 3 1,500 4 2,500 Total 7,0...
average
DAX
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    OK, you'll need to replace Table[Business Unit] with year and month columns from your date table.

     

    Avg per Month =
    AVERAGEX(
    SUMMARIZECOLUMNS(Date[Year], Date[Month],
    "@Cost", [Cost]
    ),
    [@Cost]
    )
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    Ok, the SUMMARIZECOLUMNS could be a problem in that case.

     

    We can change that to a SUMMARIZE.

     

    Avg per Month =
    AVERAGEX(
    SUMMARIZE(DIM_DATE, DIM_DATE[Year], DIM_DATE[Month]),
    [Cost Measure]
    )
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, I'm having the same issue for creating a filterable average in a card visualization.

I would like a card to display an average tool usage based upon a tool and the amount selected on a slicer.

I am very new to DAX formulas so any help would be great.  Here is a sample of the data:

DateUserApplication
12/14/2022user1Tool 1
12/14/2022user2Tool 2
12/14/2022user1Tool 1
12/19/2022user2Tool 3 
12/27/2022user3Tool 2

 

Imagine 80K rows of this data highlighting tool and user usage per day (each login is its own row).  I need a formula that will average that information based on upon the timeframe selected on the slicer.

Thanks for your help.

Tom