Forum Discussion

Relannes's avatar
Relannes
Frequent Visitor
3 years ago

How can I find the difference between two filtered values?

Hello! I'm from Brazil, so I'm sorry if some images are in portuguese or if my english is bad (and I'm also new to Power BI so be patient with me hehe).   But basically i need to calculate the diff...
Need Dax
Need Help
Show and Tell
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

You can then use measures to calculate the differences.  Give it a try and see if that setup makes it easier for you.

Relannes's avatar
Relannes
Frequent Visitor
3 years ago

Just did the calendar table and re-did the relationships. Tried unpivotting the table but since i need the value per each index in a card, i wasn't able to calculate the difference, so i kept the index structure.

 

The cards change according the filters just fine, but even after this changes, the measure i've created to do the difference it's still not working. Do you have any idea why's that?

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Rewrite your measures to use the calendar date as needed.

    • Relannes's avatar
      Relannes
      Frequent Visitor
      3 years ago

      Could you show me how would you rewrite the measures to appear the difference? Because i tried doing that, but it's still not working. Don't know if i'm doing something wrong.. take a look below