How to calculate the measure to only show at grand Total level

[shaikhzdandg]

I have created few measure to calculate the ID&V percentages named (pass Rate% and Fail Rate%). However when I throw this measure on the visual (using matrix visual) it then show values for other items of ID&V which I do not want to show and instead must be displayed as ) 

Pass Rate % = 

CALCULATE(DIVIDE([Pass-One to One Match],[Conversation_ID Count],0))


Fail Rate % = CALCULATE(DIVIDE([Total Fail],[Conversation_ID Count],0))

Below is what I am expecting the final result to look like 

What I am gettint with above formula measure 

[danextian]

Hi @shaikhzdandg 

Please try this:

Fail Rate % =
VAR _RowLabel =
    SELECTEDVALUE ( 'table'[row label] )
RETURN
    IF (
        HASONEVALUE ( 'table'[row label] ) && _RowLabel = "Fail - Mutliple Matches",
        CALCULATE (
            DIVIDE ( [Total Fail], [Conversation_ID Count], 0 ),
            REMOVEFILTERS ( 'table'[row label] )
        ) + 0
    )

Pass Rate % =
VAR _RowLabel =
    SELECTEDVALUE ( 'table'[row label] )
RETURN
    IF (
        HASONEVALUE ( 'table'[row label] ) && _RowLabel = "Pass - One to One March",
        CALCULATE (
            DIVIDE ( [Pass-One to One Match], [Conversation_ID Count], 0 ),
            REMOVEFILTERS ( 'table'[row label] )
        ) + 0
    )

[Demert]

Hi @shaikhzdandg  

If I understand correctly you only want to show the pass rate % for IDV_Summary that contains "Pass - One to One Match" and for Fail Rate % you only want to show the value for "Fail - Multiple Matches"

To accomplish this result I suggest you edit your dax measures for example:

Pass Rate % = 

if(selectedvalue('Table'[IDV_Summary]) = "Pass - One to One Match",CALCULATE(DIVIDE([Pass-One to One Match],[Conversation_ID Count],0)), blank())

Fail Rate % = 
if(selectedvalue('Table'[IDV_Summary]) = "Fail - Multiple Matches",CALCULATE(DIVIDE([Total Fail],[Conversation_ID Count],0)), blank())

You can return 0 or blank() if the statement is not true

[shaikhzdandg]

Hi @Demert 

Thanks for this, but its not showing me the results, with this selectedevalue() function. Please note we dont want to give user the option to filter or select the (pass-One to One match) option here, The measure should be calculated in a way that should give the result I showed above in excel file (see above screen shot) Thanks 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result clearly.

[Demert]

Hi are you sure you followed everything correctly? When selectedvalue is used in a table / matrix visual it will also work without the user selecting a value because it will take the row context. 

I get the following output with the measure i provided.

[shaikhzdandg]

Yes, everything is same as per your suggestion, not sure why its not working on my end, see below what the Pass Rate % is showing after applying your logic 

[v-aatheeque · Accepted solution]

Hi @shaikhzdandg ,
@Demert Thanks for your prompt response In addition to that ,
Based on the above screenshot and the measure you shared , we understood that from you DAX query that 

• Inside a row like "Apr-25", where only "Pass - One to One Match" rows are already filtered, both:

        [Pass-One to One Match] = 46,402

         [Conversation_ID Count] = 46,402

Output : 46,402 / 46,402 = 100%

but your expected results is :

46,402 / total IDV records in Apr-25 = 55%

can you prefer this below DAX query in your case : 

Pass Rate % =
IF (
    SELECTEDVALUE(Fact_IVR_Outcome[IDV_Summary]) = "Pass - One to One Match",
    DIVIDE(
        [Pass-One to One Match],
        CALCULATE([Conversation_ID Count], REMOVEFILTERS(Fact_IVR_Outcome[IDV_Summary])),
        0
    ),
    BLANK()
)

 
Hope this helps !!

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[v-aatheeque]

Hi @shaikhzdandg 

Just checking in to see if the suggestions shared by @danextian @Demert @danextian  earlier helped address your question about calculating the ID&V percentages (Pass Rate% and Fail Rate%).

If your issue is resolved, it would be great if you could mark the response as accepted  it can help others who might have similar questions in the future.

If you still need to use a Table visual for specific reasons, or have other requirements, please feel free to share a sample or explain a bit more about your scenario.

We’re always here to explore alternative solutions with you.

Thanks again for being part of the community!

[v-aatheeque]

Hi @shaikhzdandg 

I wanted to check in and see if you had a chance to review the responses provided by contributors regarding your scenario on  measure to calculate the ID&V percentages named (pass Rate% and Fail Rate%).

If their solutions addressed your issue, it would be great marking one as the Accepted Answer this helps others in the community who might be facing similar challenges. However, if you still need further clarification or are encountering issues, feel free to share additional details. We're here to help!

If we don’t hear back soon, we may close this thread in accordance with our community guidelines. That said, you're always welcome to start a new discussion whenever needed.

Thank you for being an active part of the Microsoft Fabric Community!

[v-aatheeque]

Hi @shaikhzdandg 

I wanted to follow up to see if the suggestions shared earlier helped clarify your question about measure to calculate the ID&V percentages named (pass Rate% and Fail Rate%). 

If this resolved your issue, please consider marking the response as accepted, as it may help others with similar questions.

However, if you have specific reasons for needing to use a Table visual, please feel free to share a sample or describe your requirements in more detail.

We’re happy to help explore other options if needed.

Thank you for being part of the community!