Forum Discussion

KayCon's avatar
KayCon
Frequent Visitor
3 years ago

Dax Measure - Average including filter

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 th...
MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

 

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:

 

Copy code
AvgValueType1 = CALCULATE( SUM('Details'[Paid]) / SUM('Details'[ZCount]), FILTER('Details', 'Details'[Type] = "Type1") ) AvgValueType2 = CALCULATE( SUM('Details'[Paid]) / SUM('Details'[ZCount]), FILTER('Details', 'Details'[Type] = "Type2") ) AvgValueType3 = CALCULATE( SUM('Details'[Paid]) / SUM('Details'[ZCount]), FILTER('Details', 'Details'[Type] = "Type3") )
 

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.