Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |