Forum Discussion
Append 2 DAX tables
Hi everyone, I have a large table that has, among many other columns, Worker ID, Compa Ratio Range before Increase, and Compa Ratio Range after Increase. We would like to compare number of worker...
Hi Anonymous ,
We can create a table contain all the range and the order number of ranges
Then we can create two measure to calculate the value.
After Increase =
CALCULATE (
COUNT ( 'Table'[Worker ID] ),
FILTER (
ALLSELECTED ( 'Table' ),
CONTAINS (
FILTERS ( RangeTable[Range] ),
[Range], [Compa Ratio Range after Increase]
)
)
)Before Increase =
CALCULATE (
COUNT ( 'Table'[Worker ID] ),
FILTER (
ALLSELECTED ( 'Table' ),
CONTAINS (
FILTERS ( RangeTable[Range] ),
[Range], [Compa Ratio Range before Increase]
)
)
)The solution for order the x-axis is to put the index column into the tooltips.
The range table does not need to has relation with other tables.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
