Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am new to Power Bi and currently havving challenges in creating an IF Statement.
Here's what I am trying to accomplish.
Status column is in Table 1
Sales count, Price and Quantity is in Table 2
What I want is something like this: If Status = "OLD",Price/ Sales Count else Price/ Sales Count times Quantity.
Appreciate any response.
Thank You!
Solved! Go to Solution.
Hi @jhen_1020,
If [Status], [Sales count], [Price] and [Quantity] are all added into the same visual, please try this similar measure:
If Status = IF ( SELECTEDVALUE ( 'Table1'[Status] ) = "OLD", SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] ), SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] ) * SELECTEDVALUE ( Table2[Quantity] ) )
Regards,
Yuliana Gu
Hi @jhen_1020,
If [Status], [Sales count], [Price] and [Quantity] are all added into the same visual, please try this similar measure:
If Status = IF ( SELECTEDVALUE ( 'Table1'[Status] ) = "OLD", SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] ), SELECTEDVALUE ( Table2[Price] ) / SELECTEDVALUE ( Table2[Sales Count] ) * SELECTEDVALUE ( Table2[Quantity] ) )
Regards,
Yuliana Gu
Hi,
Is there a connecting column between the 2 datasets? If yes, then which one is it?
the two tables are connected by name.
Hi,
Share the dataset and show the expected result.
HI @jhen_1020
Are you trying to add a calculated measure or column? If you are trying to add a calculated column, which of the tables are you adding it to?
Hi, I am trying to add a measure.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |