Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |