Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
The dataset that I'm using has a profit column that contains both profit and loss numbers.
Now I am trying to evaluate Total Profit by filtering the column with values greater than 0 and loss with values less than 0.
But I have to specify another condition that whenever I am filtering the data through a slicer it should not impact my Total Profit card visual.
Now I can do that by editing interactions but I want to achieve it by using Dax.
OrderBreakdown and Calendar Tabales do not have a relationship
Thank you in advance.
Solved! Go to Solution.
Not sure on this, but I think it might be something like:
[My Measure] = CALCULATE ( SUM ( 'table'[column] ), ALL ('table 2'[column you don't want affecting the filtering]) )
(sorry for the 'air-ware')
Hope this helps
Proud to be a Super User! | |
Not sure on this, but I think it might be something like:
[My Measure] = CALCULATE ( SUM ( 'table'[column] ), ALL ('table 2'[column you don't want affecting the filtering]) )
(sorry for the 'air-ware')
Hope this helps
Proud to be a Super User! | |
It worked. Thank you so much.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |