The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!