Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi!
From the example below i would like to filter sales in period 2020-01 where sales is more than 80. But i would likte to get all periods for companys that have sales of more than 80 in period 2020-01. Desired result should be to see Amazon sales in period 2020-01 and 2020-02 but not microsoft sales. is that possible and how to solve that?
Br
Arne
Example
Company Period Sales
Amazon 2020-01 90
Amazon 2020-02 70
Microsoft 2020-01 75
Microsoft 2020-02 100
Solved! Go to Solution.
Hi @Arne ,
Try this measure:
Measure 2 =
Hi Greg!
In the example it would work but in my solution i,ve got hundreds of departments so i would need some solution that first filters out every department that has sales over a specific limit for a selected period and then i would like to see sales trends for these companys for the periods i choose. So it,s really a two step issue.
1. Find companys that qualify for selected sales level for the period i choose.
2. For companys that qualify for the first criteria show sales level for the period in first critera but also for other chosen periods.
Br Arne
Hi @Arne ,
Try this measure:
Measure 2 =
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |