Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Bonjour à tous,
Voilà ce que je fais dans Excel, et je ne trouve pas comment le reproduire dans Power BI :
Je compte le nombre de valeurs B2B/B2C à l'aide d'un tcd :
et je fais un second tcd sur le 1er, pour en tirer un poids :
dans Power BI, je parviens à reproduire la 1ère étape, mais je ne parviens pas à calculer les % :
un grand merci pour votre aide
Hi, @VALMITZI ;
Try to create a measure.
measure =
DIVIDE (
CALCULATE ( COUNT ( [B2B/B2C] ), 'table'[B2B/B2C] = "B2B" ),
CALCULATE ( COUNT ( [B2B/B2C] ), 'table'[B2B/B2C] = "B2C" )
)
Then add matrix visual in powerbi desktop.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
Solved: How to upload PBI in Community - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello and thank you very much for your help !
Alas the solution does not work because I need to count aggregate crosses in my table. You can see that my table has several rows of movements concatenated on one row in my pivot table as follows:
the expected calculated result is this :
Thank you very much !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |