Forum Discussion
Total sales with specific filter
I finally used a measure that sums 2 measures, one without filters and the other with filters, probably not the most efficient but for now it works, thanks for replying anyway.
Hi DavidQuerol,
Without data is difficult to give a correct answer but to what I can understand you want on of your companies that have the YES and NO values on the column Group client and you want to calculate the sum of all no and yes for that customer alonside with all the ones that have no?
Is this correct? Dependending on your model there can be made using different measures.
Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
I finally used a measure that sums 2 measures, one without filters and the other with filters, probably not the most efficient but for now it works, thanks for replying anyway.