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 Team,
Need help with DAX for dynamic text on Button.
So we have a table
gear id | sop | confluence path |
1 | batch | https://.... |
4 | rfb | |
8 | job | https://.... |
I want a query that will follow these 4 conditions :
Please note : Confluence path is Web url.
I tried many dax , the problem I am facing is condiotion 2 and 3 are not working together.
my dax :
Solved! Go to Solution.
Hi @FaisalImam ,
According to your description, here's my solution, create a measure.
Measure =
IF (
ISFILTERED ( 'New Sops'[SOP description] ),
IF (
COUNTROWS ( VALUES ( 'New Sops'[SOP description] ) ) > 1,
"Error",
IF (
MAX ( 'New Sops'[Confluence path] ) = BLANK (),
"Not available",
"click to rediect "
)
),
" Choose SOP to view"
)
Get the correct result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @FaisalImam ,
In a measure, MAX usually used to return the current row, here it can return the correspongding [Confluence path] to the selected [SOP description].
Best Regards,
Community Support Team _ kalyj
Hi @FaisalImam ,
According to your description, here's my solution, create a measure.
Measure =
IF (
ISFILTERED ( 'New Sops'[SOP description] ),
IF (
COUNTROWS ( VALUES ( 'New Sops'[SOP description] ) ) > 1,
"Error",
IF (
MAX ( 'New Sops'[Confluence path] ) = BLANK (),
"Not available",
"click to rediect "
)
),
" Choose SOP to view"
)
Get the correct result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you please explain what is the Max function doing here -
MAX ( 'New Sops'[Confluence path] ) = BLANK (),
Hi @FaisalImam ,
In a measure, MAX usually used to return the current row, here it can return the correspongding [Confluence path] to the selected [SOP description].
Best Regards,
Community Support Team _ kalyj
Something like the following may solve your issue
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 |
---|---|
99 | |
98 | |
76 | |
66 | |
59 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |