Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
I got one column which has three values which I need to count the totals on. Ie. Total - Pizza, Spaghetti, Ice Cream.
I've created 3 measures so I can count the amount of sales and estimates against pizza / spaghetti / ice cream. But when I put it in a table the measures don't add up properly.
I can't create columns because of a depedency. I tried using 'values' and 'hasnofilter' but neither worked.
Does anyone have any tips?
Thanks!
Thanks @Dhacd
My equation:
Thanks Atma,
I tried to copy the data into an excel to demonstrate but it's quiet complex and private.
Can we do a screen share?
Cheers,
Please share the sample table as well as the measure used.
Regards,
Atma.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |