Forum Discussion

JTPorterfield's avatar
JTPorterfield
Icon for Advocate I rankAdvocate I
8 years ago

Measure to Show Only Projects that Fit Budget when Ranked

Hey all, on another post, I posted a really long winded explanation of a huge problem that I was fortunate to have help from user Greg_Deckler in figuring out.  In discovering the way forward, I thou...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi JTPorterfield,

 

Do you mean you can do it with a calculated column but not with a measure? Can you share it?

 

 

Best Regards,
Dale

JTPorterfield's avatar
JTPorterfield
Icon for Advocate I rankAdvocate I
8 years ago

v-jiascu-msft,

I posted the formulas I used to use calculated columns in message 9 of this post - https://community.powerbi.com/t5/Desktop/Issues-with-Query-Parameters-Needing-to-Refresh-Data-Source/td-p/526890

 

I've also found a measure solution, but it only works when used in a table, which is only part of what I'm looking for.  I've attached your original PBIX with the measures added, and a few more rows of data.

 

 

*edit - well, I thought I attached it, but apparently I don't have access to do so.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi JTPorterfield,

     

    You can upload the file to a cloud drive like OneDrive, GoogleDrive then share the download link here. Please mask the sensitive parts first.

     

     

    Best Regards,
    Dale