Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey,
I am working on a project dashboard.
Therefore i have 7 Projects in my Database (Projectnumber) and I would like to have an intereacitve revenue -depending on my overall filter:
Projectnumer | Revenue by Day | Revenue Multiple per Day |
195 | 30 | 26 |
333 | 25 | 25 |
456 | 31 | 90 |
123 | 26 | 84 |
Normal revenue formula (for one Project) = Revnue py Day x Revenue Multiple per Day x 360
Is there any one how can help mit with this formula - how to calculate my revenue depending on the Projects which i have selected via filter on my dashboard. Thank you Simon
Hy @Adescrit ,
thank you for your respond - i dont get the conecting to my ongoing fylter...
See below that is my measure with i am working with:
Parameter LP = Revenue by Day
Parameter BSS = Revnue Multiple
Parameter = Name of my Tabel
Thank you
Hi @NomisSimon
You can try the following:
SUMX( TableName, TableName[Revenue by Day] * TableName[Revenue Multiple per Day] * 360 )
Just replace TableName with the name of your data table contianing the project number and revenue columns.
Hey Adescript,
thank you very muche, with your quick respond.
I tried it already - i get an value but - the value is not changing if i am changing my project - your formula seems to add up all revenues together - but i need them separate depending on my filter.
Thank you
Hi @NomisSimon
It seems to be working for me, unless I have misunderstood your request:
In the example above the Revenue measure is only displaying the revenue for the filtered project numbers.
Did you definitely create a measure and not a column?
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |