Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I want to calculate linear average line for Line graph (Average line of below picture is from fucntion)
I try to use DAX as CALCULATE(AVERAGEX(),ALLSELECTED()) but it not work I found problems
1. I linked Month Master[Month Name] With Test[Month] but the data is not show due to X-axis don't change as filter (From Month Master). But if I use Test[Month] as filter, it's my expectation.
2. I want X-axis are BATCH ID but can filter by Month
3. It's will be a slot on line graph if there are blank cell in my query.
Please help me, I try for many days to solve
I've uploaded my file as below link
https://drive.google.com/file/d/1JL6Hyt3z3wtDqA1bmOLjWAn1IMN8-paR/view?usp=sharing
User | Count |
---|---|
14 | |
9 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |