Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello folks,
I have a problem. I am going to try to explain as detailed as possible, but in case questions arise, please do not hesitate to ask.
I have got a visual which consists out of many measures. These measures calculate different collumns in different tables.
The values are dynamic by and I can filter them by different contexts.
I also need the totals. Those are supposed to be used as KPIs.
Screenshots below:
In the visual it is supposed to show the total of all the lines (being filtered here). Right now it uses the previous total.
Example:
[NAZ-SOLL] = [GLZ-STUNDEN] * [NAZ-TAGE]
Right now it calculates the sums. It is supposed to calculate the values on its own and THEN sum them up.
Can anyone help?
All the best,
c4ss10p314
Solved! Go to Solution.
Not sure I follow, but perhaps: Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
@Anonymous
Take a look at ISINSCOPE as well.
Thank you very much! I've already solved it by creating the measure as a virtual table, but that would probably work as well
I solved it as you say. with the virtual table creating there my constant value. Thank you.
But if I use few values I have to create multiple tables, right?
Any more optimal way?
It's apparently fairly simple.
We used SUMMARIZE to create a virtual table.
@Anonymous ,
For multiplication, we should sum(A*B), if not then sum(A)* Sum(B) need a common context
[NAZ-SOLL] =sumx(summarize(Dim,Dim[Common],"_1", [GLZ-STUNDEN],"_2", [NAZ-TAGE])[_1]*[_2])
Also, refer how to use context: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Not sure I follow, but perhaps: Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |