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 all,
I have two tables (Table & Table(2)) related through "z_score_rnd" column.
I need to show "100" (number) value in "score %" colum for the scores, which are >=4 or <=-4 from Table(2).
Is it possible to get "if z_score_rdn >=4 or <=-4, then score % = 100, else show values from Table1 score% column".
I tried:
Column = IF('Table2'[z_score_rnd]>=4 || 'Table2'[z_score_rnd]<=-4, 100)
If I would only know how to implement false value (false should be all remained % values from Table1, "score %" column)...
Please see attached pbix file.
https://www.dropbox.com/t/sQuwN2DmUUxbsqHi
Solved! Go to Solution.
Hi @gduobaite ,
You can create this column:
Column =
IF (
( [z_score_rnd] >= 4
|| [z_score_rnd] <= -4 )
&& [z_score_rnd] IN DISTINCT ( 'Table (2)'[z_score_rnd] ),
100,
[score %]
)
Attached the file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried:
Column = IF('Table2'[z_score_rnd]>=4 || 'Table2'[z_score_rnd]<=-4, 100)
If I would only know how to implement false value (false should be all remained % values from Table1, "score %")...
Hi @gduobaite ,
You can create this column:
Column =
IF (
( [z_score_rnd] >= 4
|| [z_score_rnd] <= -4 )
&& [z_score_rnd] IN DISTINCT ( 'Table (2)'[z_score_rnd] ),
100,
[score %]
)
Attached the file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@gduobaite , I am not able to get any logic to connect to the table, can you explain, what is logic we have join these two.
in Table1 there are scores ("score") with its value in % form ("score %").
Let's say probability to have a malaria is -3.02, that mean its 33 % below populiation avg. If score is 0,89, then you have 90 % chance to sick above population avg. BUT whole scores are in Table2, not in Table1 (there are scores only between -4 and 1, while Table2 handles 19, -87.4 and so on.)
So I need to have a column with % values from the Table1 WITH the 100 % values if score from Table2 is >=4 or <=-4.
I very hope it explained a little more..
you will need to add your pbix to dropbox or something similar so we can download from there.
Proud to be a Super User!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |