As i said i'm still new. Thanks for the efforst though
That's why I was asking for sample data that helps to recreate your issue - helping to solve your issue
These are the only three raw data columns i'm using:
Rank: Rank = RANKX(ALLSELECTED('Last Quarter'),Calculate(Sum('Last Quarter'[Loan Amount]),AllExcept('Last Quarter','Last Quarter'[C LO Name])),,DESC,DENSE)
Total Units: Distinct Count of Loan Number
Total Volume ; Sum of Loan Amount
Avg Units is : CALCULATE(DISTINCTCOUNT('Last Quarter'[Loan Number])/3)
Avg Volume: CALCULATE(SUM('Last Quarter'[Loan Amount])/3)
Just one final question
What are calculated columns and what are measures?
They are all calculated columns.
I figured it out!!!! I had to make my expression a measurement and not a calculated column!!!! So embarassed thank you for your help~!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.