Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this forumla in Spotfire, Min(if([section]="red" and [category]="high",[depth])) over ([area],[block]). How can I write Dax for this in Power Bi?
Solved! Go to Solution.
Hi @feiwu2024 ,
Thanks for the reply from @lbendlin .
“Min(if([section]=”red“ and [category]=”high“,[depth])) over ([area],[block])” seems to calculate the minimum depth for records whose section is “red” and category is “high”, and group them by area and block.
Replace it with the syntax of DAX measure:
MinDepth =
CALCULATE(
MIN(Table[depth]),
FILTER(
Table,
Table[section] = "red" && Table[category] = "high"
),
ALLEXCEPT(Table, Table[area], Table[block])
)
You can learn more about these functions from the official documentation below:
CALCULATE function (DAX) - DAX | Microsoft Learn
MIN function (DAX) - DAX | Microsoft Learn
FILTER function (DAX) - DAX | Microsoft Learn
ALLEXCEPT function (DAX) - DAX | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
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!
Hi @feiwu2024 ,
Thanks for the reply from @lbendlin .
“Min(if([section]=”red“ and [category]=”high“,[depth])) over ([area],[block])” seems to calculate the minimum depth for records whose section is “red” and category is “high”, and group them by area and block.
Replace it with the syntax of DAX measure:
MinDepth =
CALCULATE(
MIN(Table[depth]),
FILTER(
Table,
Table[section] = "red" && Table[category] = "high"
),
ALLEXCEPT(Table, Table[area], Table[block])
)
You can learn more about these functions from the official documentation below:
CALCULATE function (DAX) - DAX | Microsoft Learn
MIN function (DAX) - DAX | Microsoft Learn
FILTER function (DAX) - DAX | Microsoft Learn
ALLEXCEPT function (DAX) - DAX | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
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!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |