Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I am begginer with Power Bi and i have the problem with Total for Measure. I need obtain sum of Measure2. I spent several hours on searching the answer and using several solutions from forum and youtube, but I didn't find the answer for my "sum".
Please find below link to my sample report.
Thank you in advance.
Hi @veron1990
This calculated measure gets pretty close. I have attached my copy of the PBIX File.
Measure6 = IF( ISFILTERED('Sheet1'[kraj]), --If not a total line then -- [measure2], -- This is the calculation for the total line SUMX( ALLSELECTED('Sheet1'[kraj]), [measure2]) )
Hello Phil,
Thank you for your answer. Unfortunately your measure is working only for first level ("kraj"). if you go one level below, you have the same value. I need the measure that will be working for all hierarchy levels and filters.
Can you please give an example of what you would like the total line to show when drilling takes place.
When i drilling the hierarchy I would like to have total line for chosen level. It means:
1. For first level (kraj) your formula is working. It should be approximately -0.8.
2. For second level (miasto) it should be sum of measure2 for this level (~-1.45):
3. For last level it should be the sum of measure2 for third level (the same value as for level2 because of small number of data, but in "real" project it will be different value).
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
82 | |
65 | |
63 | |
57 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |