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.
Hi,
In tableau, I've calculate the numeric distribution like this: max({ FIXED [Date],[Brand] : sum({ FIXED [BusinessID],[Date],[Brand]: max([Value])})}). And I want to calculate the same formula, but in PowerBI, it must show something like this:
Thanks
Solved! Go to Solution.
Hi @Alessandra,
The formula of DN could be the one like below according to your data.
DN Measure = SUMX ( SUMMARIZE ( 'Table2', 'Table2'[Channel], "MaxSubtotal", MAX ( 'Table2'[Subtotal] ) ), [MaxSubtotal] )
Best Regards,
Dale
Hi @Alessandra,
This could be easy with using Matrix visual. You can check it out in this file.
Best Regards,
Dale
Hi v-jiascu-msft,
Thanks, but what I really need is the formula of Numeric Distribution (DN) in PowerBI and I didn't see the formula in your file 😞
https://ibb.co/crtqkG
https://ibb.co/jAvQKb
Hi @Alessandra,
I have no idea about Numeric Distribution (DN). Could you please give an explanation and a sample file?
Best Regards,
Dale
Sorry for my **bleep**ty bad explanation, DN is the number of points of sale in which the products are distributed. For example, in the file, I have the column City and Channel (of distribution) , and first, I want to calculate the Max per Channel so I can have the sum of it. That column would be in Power BI the Numeric Distribution (DN).
https://drive.google.com/open?id=1FsqD5RnYq573kpeBwD6HzgYxPIJ9DDir
Hi @Alessandra,
The formula of DN could be the one like below according to your data.
DN Measure = SUMX ( SUMMARIZE ( 'Table2', 'Table2'[Channel], "MaxSubtotal", MAX ( 'Table2'[Subtotal] ) ), [MaxSubtotal] )
Best Regards,
Dale
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |