Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team
It me again lol. Normally i am good with creating measures but for some reason i am not getting a monthly breakdown in my table. I am getting the same total for all months. it even create a total for a blank month? So what the measure is doing its counting the number of members from the accounts table but its filtering if there been more that 1 transaction from the BalanceAdjustment table.
Relationships:
FeeDate[Date] 1 to many Aufsaaccounts[createdon]
FeeDate[Date] 1 to mant BalanceAdjustments[Date]
BalanceAdjustment[AccountNumber] Many to many a au_fsaccountses[fsaacountreference]
Im not sure what im doing wrong. I checked all the dates format and it is correct?
thanks
viral
I think it may be the many to many relationship that caused the measure you created to return the same result .
Could you provide some data or sample ? According to your diagram, I have no way to determine the specific reason .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@viralpatel21 , Data model has an issue. You should remove that M-M join if need to have more dimension/bridge table like feedate. Once you remove that many to many, you can update those as active relationship
https://www.seerinteractive.com/blog/join-many-many-power-bi/
hi @amitchandak
thanks for the reply. Im still getting confused on how to do that?
But if i didnt remove the M-M relationship because there are more tables that factors into the data model... how would i fix the current problem?
thanks
viral
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |