Grand total row is not correct

[Trodo7377]

I'm using the following measure as Values in a Matrix. It shows correct numbers for each row in Total column but not in Total row:

m_b1 = 
VAR BaseTable =ADDCOLUMNS(
    SUMMARIZE(
        'abc',
        'abc'[FIB]),
        "sum", CALCULATE(DISTINCTCOUNT('abc'[ID]))
    )
RETURN
SUMX(
    BaseTable,
 IF([sum] > 1, [sum], blank())
)

How to change the measure to get correct on Total row?

[v-pnaroju-msft]

Hi Trodo7377,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[Trodo7377]

Hi @v-pnaroju-msft  The customer who ordered Matrix visualisation changed his order to a simple barchart and there is no need anymore using the measure I sent before.

[v-pnaroju-msft]

Hi @Trodo7377,

Thank you for the update regarding your client’s revised requirements.

We understand that the original requirement has now changed; however, we would appreciate it if you could kindly review the solution we provided earlier, which was based on your initial query. If the proposed approach addressed your original query, please consider accepting it as a solution. This will greatly benefit other community members who may encounter similar scenarios in the future.
Should you require assistance with the revised requirements, please feel free to share the new details, and we will be pleased to assist you further.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi @Trodo7377,

We sincerely appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries.
Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.
Thank you.

[techies]

Hi @Trodo7377 measure seems correct, can you pls share sample pbix file?

[Trodo7377]

Unfortunately, I cannot share organizational data here.