Forum Discussion
wrong total value in table
Hello Power BI Forum,
I have a table with the columns TARIFF, SEGMENT, ARTICEL and the following measure to calculate with right total sum:
Hello,
HASONEVALUE(TABLE[TARIFF]) && HASONEVALUE(TABLE[SEGMENT]) && HASONEVALUE(TABLE[TARTICEL])
instead of
HASONEVALUE(TABLE[TARIFF])
helped.
Many thanks.
3 Replies
Pikachu-Power If that segment has a single associated TARIFF, then you wouldn't get the SUMX behavior but rather just get the results of the [Deviation_eur] measure, which might be wrong, it's hard to know without more information.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi,Greg_Deckler ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Pikachu-Power .I am gald to help you.
Could you please check if there is a problem with the use of the functions?In Power BI Matrix, we often use ISINSCOPE, ISFILTERED and HASONEVALUE to check the status of the filters in our data model.
Generally used to determine the hierarchy, there is a difference between the three of them:
Matrix BUG in PBI ? - Microsoft Fabric Community
ISINSCOPE function control total output:
https://community.fabric.microsoft.com/t5/Desktop/Counting-on-row-level-unique-values-in-MatrixTable/m-p/4338174#M1357171
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello,
HASONEVALUE(TABLE[TARIFF]) && HASONEVALUE(TABLE[SEGMENT]) && HASONEVALUE(TABLE[TARTICEL])
instead of
HASONEVALUE(TABLE[TARIFF])
helped.
Many thanks.
