Forum Discussion
aallman
Helper II
Helper IIMeasure based on Multiple Slicer Selection
Hello! I have a measure to calculate fail rate. Right now it is actually a couple of measures: one counting all the fails, one counting the total items, and a third that does the calculation to turn...
Hi,
I am not sure if I understood your question correctly, but please try something like below and check whether it works.
If you are using ALL DAX function in one of your measures, please try using ALLSELECTED DAX function.ALLSELECTED function (DAX) - DAX | Microsoft Learn
expected result measure: = VAR _failcount = [failcount measure] VAR _allitemcount = CALCULATE ( [itemcount measure], ALLSELECTED () ) RETURN DIVIDE ( _failcount, _allitemcount )
Hi aallman ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!