Forum Discussion
Solved
How do I create a % formula between fields
Hi All, I have a data format like this Account Group Amount Acc1 Group1 200 Acc2 Group1 400 Acc3 Group1 100 Acc4 Group1 300 Acc1 Group2 150 Acc2 Group2 600 Acc3 Group2 200 Acc4 Group2 20...
Hi,
Please check the below picture and the attached pbix file.
Amount measure: = SUM( Data[Amount] )Percent measure: = VAR _acc1 = CALCULATE ( [Amount measure:], Account[Account] = "Acc1" ) VAR _amount = [Amount measure:] RETURN IF ( HASONEVALUE ( Account[Account] ) && HASONEVALUE ( 'Group'[Group] ), DIVIDE ( _acc1, _amount ) )
Hi,
Please check the below picture and the attached pbix file.
Amount measure: =
SUM( Data[Amount] )
Percent measure: =
VAR _acc1 =
CALCULATE ( [Amount measure:], Account[Account] = "Acc1" )
VAR _amount = [Amount measure:]
RETURN
IF (
HASONEVALUE ( Account[Account] ) && HASONEVALUE ( 'Group'[Group] ),
DIVIDE ( _acc1, _amount )
)
