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

      • v-dineshya's avatar
        v-dineshya
        Community 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.