topic Re: How to get a AVG measure from a Card in DAX Commands and Tips

How to get a AVG measure from a Card

OCBB_SFAFPandA — Fri, 08 Jul 2022 00:22:23 GMT

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

Re: How to get a AVG measure from a Card

VahidDM — Fri, 08 Jul 2022 01:20:13 GMT

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

Re: How to get a AVG measure from a Card

Anonymous — Tue, 12 Jul 2022 05:50:11 GMT

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.

Re: How to get a AVG measure from a Card

OCBB_SFAFPandA — Tue, 12 Jul 2022 17:28:14 GMT

Thanks, this works!