Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I want to divide a Matrix row with the line above it in Power BI and I coudnt find a solution to it. please look at the below pivot table in the below link. i couldnt attach file so i am put that on Google sheets.
https://docs.google.com/spreadsheets/d/1nD0H12eUBbtV5YaBrMiswKLpGlhoOYQ5eM4Et_yOx8A/edit?usp=sharing
I need the second table to dynamically respond to the first table. In the file columns are 'country' but if I re place it with Region it should change dynamically. It can be easily done in excel but I am struggling to show that in Power BI.
Any help is appreciated
Solved! Go to Solution.
@Beyeservices , we do not have any method two subtract from last row
but we can do like this
This Stage= CALCULATE(sum('order'[Qty]),filter(ALL('Stage'),'Stage'[Stage]=max('Stage'[Stage])))
Last Stage= CALCULATE(sum('order'[Qty]),filter(ALL('Stage'),'Date'[Stage]=max('Stage'[Stage])-1))
diff = [This Stage] -[Last stage]
if they not numeric we can have rank on them that can work
This Stage= CALCULATE(sum('order'[Qty]), FILTER(ALL('Stage'),'Stage'[StageRank]=max('Stage'[StageRank])))
Last Stage= CALCULATE(sum('order'[Qty]), FILTER(ALL('Stage'),'Stage'[StageRank]=max('Stage'[StageRank])-1))
Hi @Beyeservices ,
You could refer to the following measure.
Measure =
VAR a =
CALCULATE (
[Your value expression],
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[Stage]
= MAX ( 'Table'[Stage] ) - 1
&& 'Table'[Country] = MAX ( 'Table'[Country] )
)
)
RETURN
IF ( a = BLANK (), BLANK (), [Your value expression] / a )
@Beyeservices , we do not have any method two subtract from last row
but we can do like this
This Stage= CALCULATE(sum('order'[Qty]),filter(ALL('Stage'),'Stage'[Stage]=max('Stage'[Stage])))
Last Stage= CALCULATE(sum('order'[Qty]),filter(ALL('Stage'),'Date'[Stage]=max('Stage'[Stage])-1))
diff = [This Stage] -[Last stage]
if they not numeric we can have rank on them that can work
This Stage= CALCULATE(sum('order'[Qty]), FILTER(ALL('Stage'),'Stage'[StageRank]=max('Stage'[StageRank])))
Last Stage= CALCULATE(sum('order'[Qty]), FILTER(ALL('Stage'),'Stage'[StageRank]=max('Stage'[StageRank])-1))
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |