Forum Discussion

jsnrchtr's avatar
jsnrchtr
Regular Visitor
1 year ago
Solved

Help building a calculation or Point me in a Direction

I have a dataflow that is sourcing from an online dataset that updates daily. My dashboard updates daily and pulls in each of probably 4 or 5 different datasets all updating the same way.    I have...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi jsnrchtr ,

    Please provide sample PBIX file and show the expected outcome based on the sample data .

     

    Thanks

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi jsnrchtr ,

 

Please refer the attached PBIX file for your reference.

 

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi jsnrchtr ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

 

Thank you.

  • jsnrchtr's avatar
    jsnrchtr
    Regular Visitor
    1 year ago

    The arrows are moving, but I'm waiting on the data to change again to confirm. I should know tomorrow as I just updated data that will reflect tomorrow in the cloud. The issue I'm having though is the arrows (with the exception of the one item that is "0" and a dash) are all changing at the same time. If Unit A goes down by 1, all unit arrows reflect the change vs. just that unit. I have each card filtered by unit but it is as if its ignoring the filter. I'm having that issue with a few cards on the dashboard I think and I'm not sure why it is choosing to filter some cards but not all cards.

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi jsnrchtr ,

      As per your requirement, i have updated the code.

       

      KPI Remaining Items (Today) =
      CALCULATE (
          COUNTROWS ( 'MMIS Status Update' ),
          'MMIS Status Update'[completion_status] = "Not Completed"
      )
       
      KPI Previous Day Remaining Items =
      VAR PrevDate =
          CALCULATE (
              MAX ( 'Date'[Date] ),
              FILTER ( 'Date', 'Date'[Date] = TODAY () - 1 )
          )
      RETURN
          IF (
              ISBLANK (PrevDate),
              0,
              CALCULATE (
                  COUNTROWS ( 'MMIS Status Update' ),
                  'MMIS Status Update'[completion_status] = "Not Completed",
                  'Date'[Date] = PrevDate
              )
          )
       
      KPI Trend Arrow Color =
      SWITCH (
          TRUE(),
          [KPI Remaining Difference] < 0, "Green",
          [KPI Remaining Difference] > 0, "Red",
          "Gray"
      )
       
      Please refer the output snap and attached PBIX file.

       

       

      If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
      Thank you.

      • v-dineshya's avatar
        v-dineshya
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi @jsnrchtr ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

         

        Thank you.