Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |