@Greg_Deckler
Okay, please see the link to a dataset and .pbix file. Thansk for your help, I am tied in knots on this one. This is the jist of what I am trying to do:
https://www.dropbox.com/sh/wsy4w3zhtc3s088/AABzGd4YyT3TxmbX_kc7NrDga?dl=0
User selects a Product, Budget and Spend Level - outputs are shown on two tiles in the dashboard.
1. Budget and Spend Level shown as currency (properly formatted)
2. Spend Level of <10,000 to be shown as "Less Than $10,000" but should be formatted as a whole number (if possible).
3. Tile identified as Cost-Per-Thousand should be shown as it appears in the table without a function. i.e. Based on the selected Product, Budget and Spend Level the Cost-Per-Thousand is...
4. Count of product based on calculation expressed in the .pbix file
Thanks for the help, it is greatly appreciated!
