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 ,

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.

  • jsnrchtr's avatar
    jsnrchtr
    Regular Visitor
    1 year ago

    Adjusted the formulas as supplied. Made one change for the arrows... > 0 Green , < 0 Red.

    All arrows are still moving at the same time and still seem to only be refreshing the first time data comes in. When the dashboard refreshes, the arrows ignore the new data. I'll verify again tomorrow morning when the dashboard will have new data changes (The source only updates once daily and I don't control the source). I am still also getting strange slicer behavior. If I click on a single unit, my completion percentage card reflects odd numbers. Total number is accurate. If i filter by a unit, that completion percentage instead of showing that units completion percentage, ballons to over 200% in some cases. 

  • v-dineshya's avatar
    v-dineshya
    Community Support
    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 I had earlier requested a sample PBIX file based on your above reponse. 
    In line with our community guidelines, we may close this thread if there's no response, but you're always welcome to create a new post if needed.

    If you need further clarification or continue to face issues, feel free to reply  we're here to help!

    Thank you for being an active member of the Microsoft Fabric Community!

     

    Regards,

    Dinesh