Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I currently have the below Measure. This works perfectly for all except for Location Code of 'SP'.
Does anyone know how I would adjust the measure so that if Location Code = SP then value = 450000. The intention is to use this in a Matrix visualisation, so Total would need to include this static value.
Solved! Go to Solution.
@Anonymous ,
You may modify the calculate column using dax below:
Currently Projected Sales = SUMX ( ADDCOLUMNS ( SUMMARIZE ( 'Current Month Sales', 'Location'[Country Code], 'Location'[Location Type], 'Location'[Location Code] ), "Projected Sales", ( ( ( [TOTAL W/O] * 200 ) + [Total Sales] ) / [Work Days So Far] ) * [Work Days] ), IF ( 'Location'[Country Code] = "SP", 450000, [Projected Sales] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You may modify the calculate column using dax below:
Currently Projected Sales = SUMX ( ADDCOLUMNS ( SUMMARIZE ( 'Current Month Sales', 'Location'[Country Code], 'Location'[Location Type], 'Location'[Location Code] ), "Projected Sales", ( ( ( [TOTAL W/O] * 200 ) + [Total Sales] ) / [Work Days So Far] ) * [Work Days] ), IF ( 'Location'[Country Code] = "SP", 450000, [Projected Sales] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |