Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am facing an issue with a basic measure I want to create :
I have a dimension table that have two values :
Y
N
This table is linked (1,n) to my fact table that have a X amount
I want a measure that gives the total of X for Y only :
-> CALCULATE(SUM(X), DIM_TABLE = Y)
The total given is good, but as soon as I cross this measure with the dimension the result is :
Y | 1000
N | 1000
Total | 1000
But I would expect :
Y | 1000
N | 0 (since the measure is filtered on DIM = Y)
Total | 1000
Could you tell me how to fix it ?
Thanks.
Romain
I think some sample data / pbix without any classified information is helpful to give right solution
Proud to be a Super User!
Yes you're right 🙂
So I have this :
I want a measure that returns only 3 565 169 673 195 on the NON_MNI row.
I have the following measure
Hello VijayP, thanks for the proposal but same issue 😞
And when I take another field from another dimension, or another field from the same dimension this measure is working...
So it seems to be wrong as soon as I want to show the measure with the same field I am filtering on...
Hi @RomainTo try this!
CALCULATE(SUM(X), filter(all(dimtable[column]),DIM_TABLE = Y)
Proud to be a Super User!
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |