Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Solved! Go to Solution.
Hi @Talal141218
Following to our discussion, you can use
=
IF (
NOT ISEMPTY ( Dim_DateEstimatedDelivery ),
SELECTEDVALUE ( Dim_DateEstimatedDelivery[DateEstimatedDelivery_NK] ) + 10
)
Hi @Talal141218
Following to our discussion, you can use
=
IF (
NOT ISEMPTY ( Dim_DateEstimatedDelivery ),
SELECTEDVALUE ( Dim_DateEstimatedDelivery[DateEstimatedDelivery_NK] ) + 10
)
Hi @tamerj1 ,
if i understand your quation my Data model is SQL Server Analysis Services and (ETD) column belong to Estimate time of dispatsh Table in another hand (container ID) column belongs to Procurements Table.
farthermore i don't know what is the relationships between the Tables, because there is IT Company create the Data Model. I have authority just to make measures and reports. nothings to do with Data.
i hope, that's i got ur Point and answered ur quations.
Thanks in Advance.
Hi @Talal141218
It looks to me that most probably both tables are fact tables. There must be some Dim table(s) connecting the two tables. If we don't have the full picture we won't be able to do anything. Maybe you cannot change (add/remove/alter) relationships but for sure you can view them either through SSAS itself or from power bi model view icon
i want to correct my statement , all belongs to one Table( Purchorderline). Data relashenship very complix i take Pic if that's enough.
@Talal141218
I thinkwe need to connect perhaps via teams or zoon later on today. Let me know if you can do that.
@tamerj1 i understand now, what do you means Etimate time of Dispatsh belong to Dim-Table and Container ID belongs to Fact- Table, and there is relationship between two tables . I apprciate your help, we can today via Teams if you wish.
me too, how can i connect you ?
if you send me ur email in private i will send you invitaion by email. i prefer not in puplic yestarday was in this site hackers attack.
thanks for ur understanding
Hi Thanks for replay
i think you right, but i am neu Power BI user can you help me to crate a measure please.
look at the pictures below please:
you will see, wenn i add the Container ID from another Tabell, the Measure dosn't work.
thanks in advance
Hi @Talal141218 ,
//i had crate a measure as you see in below and want to use this as column in Matrix
The matrix does not accept measure as its column value fields.
Please consider creating a calculated column. Can you explain what you expect the result to be?
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thanks a lot for ur replay,
i want to add a column to increase the date 10 Tage.
and i faced problems as below:
than after i add the Container ID so :
thanks in advance
Hi @Talal141218
I suspect that the value of th measure is not filtered when placed inside the visual. If this is the case then you need to add some CALCULATE - CROSSFILTER - BOTH agument in order to transfer the filter from one dim. to another.
Hi,
how can i do that ? sorry i am neu user in Power BI.
Thanks alot.
Hi @Talal141218
please share more details about your data model and relationships. Also indicate which columns and in which tables are we talking about.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |