Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

Power BI is Not summing up correctly

Hello,   I have found that Power BI does not Accuratley summarize columns in the Table Matrix.     First Column:    Balance USD = IF('BSA00-RMMC'[RMDTYPAL]<7,'BSA00-RMMC'[ORTRXAMT],IF(ISBLANK('B...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

lcasey

 

The issue is the [EXCHRATETOUSE]  when is all customer selected (Total) his value is blank.

 

To solve this create another measure [EXCHRATETOUSE2] and Add before the last ) this ,1

 

Use [EXCHRATETOUSE2] in your second measure

  • lcasey's avatar
    lcasey
    Icon for Post Prodigy rankPost Prodigy
    9 years ago

    Hello Vvelarde,

     

    Would you be available as a paid consultant to complete a few reports we are developing in Power BI?

     

    Would be happy to pay you for your time. 

    • v-micsh-msft's avatar
      v-micsh-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi lcasey,

       

      What is your current situation?

      If you still need any further assistance on this topic, then please post back and we will see what we could suggest.

      In addition, if you are using SSRS 2016, then it would be possible to PIN dashboard directly from SSRS to Power BI.

      Pin Reporting Services items to Power BI Dashboards

      Regards