Forum Discussion
Dynamic Total Count Percentage
Hi Sagar01
Please refer to the following solution.
1.Create a measure to calculate count of stage.
Total Opportunities= Count(Opportunity[Stage])2. Create another measure to calculate %
% Opportunities = VAR a = CALCULATE ( [Total Opportunities], FILTER ( ALLSELECTED ( Account ), [Billing Country] IN VALUES ( Account[Billing Country] ) ) ) RETURN DIVIDE ( [Total Opportunities], a )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The sructure is like Accounts table is connected to Opportunity table in one to many relationship and we are getting Billing Country from accounts table
Hi Sagar01
Please refer to the following solution.
1.Create a measure to calculate count of stage.
Total Opportunities= Count(Opportunity[Stage])2. Create another measure to calculate %
% Opportunities =
VAR a =
CALCULATE (
[Total Opportunities],
FILTER (
ALLSELECTED ( Account ),
[Billing Country] IN VALUES ( Account[Billing Country] )
)
)
RETURN
DIVIDE ( [Total Opportunities], a )
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.