Forum Discussion
Distribution Point Calculated on Power BI
Hi All, Could anyone help me solve below business scenarions? Distribution Point Definition: One product sold to one customer with real purchasing value amonnt ( we might send customer samp...
If you can post some sample raw data I can be more specific. Otherwise, the general replacement for COUNTIF in DAX is CALCULATE like so:
Measure = CALCULATE(COUNT([Column]),FILTER(Table,[Column/Measure] > 0))
Something along those lines.
Thanks for your quick reply
And please see below raw data and it is quite falt comparing with pivot table.
If only used below calculated measure, it would only get the how many products are sold, right?
Can you please help me? Thanks