Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
tksnota
Post Patron
Post Patron

Decomposition Tree Need to Counting based on Classification

Hi,

 

Is it possible for the count to capture the count of projects based on classification. Will the counting still be dynamic meaning the numbers change while the several classifications are being selected

 

Thanks...tksnota...

 

 

tksnota_0-1729504704520.png

 

4 REPLIES 4
Anonymous
Not applicable

Hi @tksnota ,

I create a table as you mentioned.

vyilongmsft_0-1729561684592.png

Then I put it into Decomposition Tree visual.

vyilongmsft_1-1729561965255.png

So I think you can create a measure.

QuantitySelected = SELECTEDVALUE('Table'[Quantity])

When I put it into a card visual, it will give you what you want.

vyilongmsft_2-1729562158452.png

vyilongmsft_3-1729562188352.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Please advise why this measure is needed and where it is used? Is this needed or just used the second measure?

 

Thanks...tksnota...

 

tksnota_0-1729758999880.png

 

tksnota_1-1729759079751.png

 

 

Anonymous
Not applicable

Hi @tksnota ,

That Measure at the very beginning is not a necessity, you can select any column in the table in Analyze.

vyilongmsft_0-1730084683504.png

For the second Measure, I am placing it in Card visual, which is able to show the specific values selected in Decomposition Tree visual.

vyilongmsft_0-1730092803124.png

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

I need to use the current margin no the project in the analyze.

 

Is still be possible to do the counting?

 

Thanks...tksnota...

 

tksnota_1-1730114577263.png

 

 

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.