Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Post Patron
9 years ago
Solved

Calculation issue due to interaction

  Hello Power BI experts.   I have little issue with one measurement.   Rate = [Measure Renewals related]/[Settlements]   Is saying that 1624 / 218 is 26.36% It should be actually 13.42%   ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi AndrejZitnay,

     

    Thanks for the detailed explanation. Now I understand it totally. And I believe it you can use ALL or ALLExcept function to get the expected result in this scenario. However, without the sample data for testing, it's hard to provide a tested and correct formula for you. So could you try the formula below to see if it works? :smileyhappy:

    Rate =
[Measure Renewals related]
    / CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )

    Regards

SivaMani's avatar
SivaMani
Resident Rockstar
9 years ago

I got it.

 

Will you be able to share your sample pbix or sample data?

AndrejZitnay's avatar
AndrejZitnay
Post Patron
9 years ago

Hello Siva,

 

It is hard to give you sample data but I get both figures as measurment with counting rows in excel.

I am sure that problem is with Edit Interaction.

 

You can see on my first picutre that it is off on first screenshot.

 

I need jsut get right calculation.

My current formula is taking into considiration interaction betwen slicers.

 

Andrej

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    9 years ago

    AndrejZitnay I have found the issue.

     

    When you disable the interaction, it will apply only on the visual. But the value selected in the slicer will filter your data i.e, the measure calculates the count from the filtered table.

     

    Let's say,

    I have a Table called Table A(has 365 rows) with the date. I added the date field to the slicer. As from your report, I have rows count as a measure called count and added in a KPI.  If select 01/01/2017 to 28/02/2017.

    If I select 01/01/2017 to 28/02/2017, the measure calculates 59. But KPI will show 365 if the interaction is off.

     

    I hope I made it clear

     

     

    Regards,

    Siva

     

    • AndrejZitnay's avatar
      AndrejZitnay
      Post Patron
      9 years ago

      Hello SivaMani

       

      It is clear however I need to get calculation right with current set up of slicers.

       

      I have complex dashboard.

      Everything is working and it is only unfortunate that one calculation doesn't work.

       

      I was hoping that there is same trick to get around that.

       

      thanks.

       

      Andrej