Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
1 year ago
Solved

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:   Measure = IF(   HASONEVALUE(TABLE[TARIFF]),   ...
Need Help
  • Pikachu-Power's avatar
    Pikachu-Power
    1 year ago

    Hello,

     

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

     

    instead of  

     

    HASONEVALUE(TABLE[TARIFF])

     

    helped.

     

    Many thanks. 

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.