Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I am trying to recreate the above formula in DAX/BI.
I am a bit of a novice but i am hoping someone can help me understand why I can't get this to work.
I have imported "Product List" into BI and have a document that contains the product code that I am trying to link to.
Would appreciate any guidance please.
Thank,
Glen
Solved! Go to Solution.
Hi, @Anonymous
Try this:
Column =
IF(
CALCULATE(
MAX( 'table'[E] ),
FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
) = "generally available",
SWITCH(
TRUE(),
[R] = "BTL", "BTL",
[T] <= 0.8, "Standard Low LTV",
[T] > 0.8, "Standard High LTV"
),
CALCULATE(
MAX( 'table'[E] ),
FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
)
)
If this does not solve your problem, could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Try this:
Column =
IF(
CALCULATE(
MAX( 'table'[E] ),
FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
) = "generally available",
SWITCH(
TRUE(),
[R] = "BTL", "BTL",
[T] <= 0.8, "Standard Low LTV",
[T] > 0.8, "Standard High LTV"
),
CALCULATE(
MAX( 'table'[E] ),
FILTER( ALL( 'table' ), [B] = "*" & [F] & "*" )
)
)
If this does not solve your problem, could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
58 | |
45 | |
42 |