wrong total value in table

[Pikachu-Power]

Hello Power BI Forum,

I have a table with the columns TARIFF, SEGMENT, ARTICEL and the following measure to calculate with right total sum:

Measure =

IF(

  HASONEVALUE(TABLE[TARIFF]),

  [Deviation_eur],

  SUMX(  

    ADDCOLUMNS(

      SUMMARIZE(

        TABLE,

        TABLE[TARIFF], TABLE[SEGMENT], TABLE[ARTICEL]

      ),

      "Total", [Deviation_eur]

    ),

    [Total]

 )

)

Now i put a slicer TABLE[SEGMENT] on the canvas and get a wrong total value when i filter for example TABLE[SEGMENT] = B. 2300 - 200 results in 1000.  Does someone see where the error is??

Many thanks for ideas.

[Pikachu-Power · Accepted solution]

Hello,

HASONEVALUE(TABLE[TARIFF]) && HASONEVALUE(TABLE[SEGMENT]) && HASONEVALUE(TABLE[TARTICEL])

instead of  

HASONEVALUE(TABLE[TARIFF])

helped.

Many thanks. 

[Anonymous]

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...

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.

[Greg_Deckler]

@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.