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 afternoon comunity,
I have a problem with a measure that is not aplying the filters that I look for
This is my data model
And I have two measures:
Yikes! That is a really complicated Data Model with multiple relationships going every which way. I hope you understand it, but my instinct tells me you don't because you are having trouble de-bugging filtering issues which is almost gauranteed with such a complicated model. And what about the next problem, and the problem after that? Do you have a plan for how to quickly address those, or will you be always coming back here for help?
My first recommendation would be to simplify your model. You will probably think that is a waste of time. And maybe you're not building this Report for a Production environment, and you would be right. Or, maybe you don't know where to begin or how to simplify a data model. But, a a little (or a lot) of time invested now will eliminate more headaches than you can count down the road. Trust me; I speak from experience.
An don´t see where you find this a complicated model.
If you pais a bit of attention instead of just critizice I focused on what is needed for this porpouse
2 dim tables 2 fact tables with correct relations between them 1 to many. The rest of the tables are not shown becasue is not necesary for the measures we are talking about.
That you don´t understand when you see lines crossing does not mean that is a complicated model, I guess as you did, that you dont work with big datasets or with cubes. Worst quality response I got in this forum, but after checking how you respond to other users It does not suprise me.
Best of luck