Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey PBI peeps,
I am trying to fill a small Income Statement and have trouble with subtotals. I am using this formula, to map specific measures to specific lines in the table (ubtotals are in bold):
For some reason, the subtotal measureas (or any measures that use other measures that are mentioned in this DAX formula) appear on the table as zeros, even though they are calculating correctly in separate visuals:
Attaching example link to example file:
https://www.dropbox.com/s/lu57ebyljvz6r1c/Example.pbix?dl=0
What am I missing here? Any help appreciated.
Solved! Go to Solution.
Thank you for the responce. I managed to solve the problem myself. It turned out that the problem was, that there was a active relationship between colum income Statement Map'[Atsiskaitymai] and And Mapping[Mapping II]
May I ask if your problem has been solved? Is the above answer helpful to you?
If it helps, could you please mark the response which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
@Anonymous , You need force some group by
Per laikotarpį priskaičiuoti atskaitymai =
VAR CurrentItem = SELECTEDVALUE('Income Statement Map'[Atsiskaitymai])
RETURN
sumx(values('Income Statement Map'[Atsiskaitymai]),
SWITCH(TRUE(),
CurrentItem = "Kitos veiklos išlaidos", [Kitos veiklos išlaidos],
CurrentItem = "Už apskaitos paslaugas", [Už apskaitos paslaugas],
CurrentItem = "Už teisines paslaugas", [Už teisines paslaugas],
CurrentItem = "Už valdymą", [Už valdymą],
CurrentItem = "Sėkmės mokestis", [Sėkmės mokestis],
CurrentItem = "Už gautų paskolų palūkanas", [Už gautų paskolų palūkanas],
CurrentItem = "Už depozitoriumo paslaugas", [Depozitoriumui],
CurrentItem = "Už auditą", [Už auditą],
CurrentItem = "Už kitas administravimo išlaidas", [Kitos veiklos išlaidos],
CurrentItem = "Nekintamas dydis", [Už valdymą2],
CurrentItem = "Visų išlaidų suma", [Visų išlaidų suma],
CurrentItem = "Bendrų išlaidų suma ir koeficientas", [Bendrųjų išlaidų suma ir koeficientas],
0))
Thank you for the responce. I managed to solve the problem myself. It turned out that the problem was, that there was a active relationship between colum income Statement Map'[Atsiskaitymai] and And Mapping[Mapping II]
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |