Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In shared document you will see measure "Final Balance", in Table "DateHelper". This measure is categorised by OperationsStatus (which itself is hierarcy level on x-axes), becouse components of "Final Balance" is categorised by OperationsStatus.
I need to calculate "Final Balance" in such way that it does not care aboute OperationStatus. In other words, I need to calculate sum of measures, that the sum do not consider x-axis hierarcy level("OperationsStatus"), while components of the sum do.
Here is the link: https://drive.google.com/file/d/1aJFnisiBNVrPQdX1a1VXxqNPufMO1xp4/view?usp=sharing
Solved! Go to Solution.
You can try something like.
Measure = CALCULATE( [Your Measure or Aggregation], ALL( 'Table'[OperationsStatus] ) )
ps. I've tried to access your GD file but permissions are not set.
You can try something like.
Measure = CALCULATE( [Your Measure or Aggregation], ALL( 'Table'[OperationsStatus] ) )
ps. I've tried to access your GD file but permissions are not set.
I have accested your answer as solution by mistake 🙂
I have already tried you approach, but it does not work for my case .
Please send notfication on vie this link: https://drive.google.com/file/d/1aJFnisiBNVrPQdX1a1VXxqNPufMO1xp4/view?usp=sharing
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |