Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Morning
I've calulated an avg. value, now I need to create 3 more split by type, I need this to be displayed on one line chart.
Can anyone help with the dax formular to add a filter on to this
Thank you for your help - got this error when I tried
The following syntax error occurred during parsing: Invalid token, Line 2, Offset 50, 'On Street"))))))).
hi @KayCon
Be careful about unclosing brakets and the DataSlayer's code shall work. Can you make a screenshot of the issue?
Or try a simplified code like this:
AvgType1 = CALCULATE([AvgValue], Details[Type] = "Type1")
AvgType2 = CALCULATE([AvgValue], Details[Type] = "Type2")
AvgType3 = CALCULATE([AvgValue], Details[Type] = "Type3")
p.s. please consider @someone, if you seek further suggestions.
To create additional measures split by type, you can use the FILTER() function to filter your data based on the value of the type column. Here's an example of a DAX formula that calculates the average value split by type:
Each of these formulas will return the average value for a different type, "Type1", "Type2" and "Type3" respectively, this way you can display them on the same line chart.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |