How to get a AVG measure from a Card

[OCBB_SFAFPandA]

Hi,

I was able to get the average measure in a table using the AVERAGE function (FACTS[transactions]), though when I put the same measure in a CARD, it shows up as 0. I want it to look like below:

Plus, I need to make sure it plays nice with my date slicer. It's a table I added to get this slicer working. It is cross filtered to "both directions"  with my date table

[Anonymous]

Hi @OCBB_SFAFPandA ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = AVERAGEX(ALL('Table'),'Table'[Average-transactions])

If I have misunderstood your meaning, please provide some sample data and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM · Accepted solution]

Hi @OCBB_SFAFPandA 

Try this measure for that card:

Average X =
AVERAGEX (
    SUMMARIZE ( FACTS, FACTS[Location], "Avg", AVERAGE ( FACTS[transactions] ) ),
    [Avg]
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[OCBB_SFAFPandA]

Thanks, this works!