The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good Morning community
another topic I'm struggeling with. Hope anybody can help me to GET OUT OFT THIS! 😉
I have two related tables:
Table_1: "Antraege[KW nach Lieferung]"
Table_2: "KPI_Einzelfälle_Gesamt"
Relation 1:M
My measure "month_8" is to sum up the running total for "Fall-Zaehler" by "KW nach Lieferung".:
____________
As far as there are values in Antraege[KW nach Lieferung] it works, but if there there can't be found a row
for SELECTEDVALUE(Antraege[KW nach Lieferung]) the measure, delivers "1". Instead of this "1", I expect to receive the latest result avialaible. For instance:
For TABLE_1[Antrage[KW nach Lieferung] 9, I expect 3, for 10 I expect 3,...for 18 I expect 14,.....
Can anybody help me here? I'm struggeling already for hours...
Thx in advance.
Last try. 😉 Nobody in the forum that could give me a hint for a solution within a measure? I need a solution independent from a visual, as I need to use the result as well in a further measure. Thank you experts!
Hi @Anonymous feature could be activate in newest pbi version on menu
File>>>Option and seeting >>>Options
Close and open again pbi file
Proud to be a Super User!
Hi @some_bih , thanks! Yes I agree. This would most likely help. But I have no glue when the new version will be avialable for me on one hand, and second,I just want to know which function(s) could provide the solution within a measure. I still hope, someone will let me know how to solve that. Regards
User | Count |
---|---|
79 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
108 | |
99 | |
55 | |
49 | |
46 |