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.
Hi Sagar01
You can refer to the following measure.
1.Create a measure to calculate count of stage.
Total Opportunities= Count(Opportunity[Stage])
2. If your Opportunity table have the country column, if it exists,the following measure use the country column in Opportunity table Create another measure to calculate %
% Opportunities =
VAR a =
CALCULATE (
[Total Opportunities],
FILTER (
ALLSELECTED ( Opportunity ),
[Billing Country] IN VALUES ( Opportunity[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.