Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
https://www.dropbox.com/s/0sy7atxc8vpfo43/SPECIAL%20CLIENT%20REPORT.pbix?dl=0
I am trying to use a 'criteria' table to calculate the sales for those clients that meet the below criterias (such as type, date period, and country)
I would like to display this information in one table so I can view both total sales and the 'selected sales' at a client level.
Have tried to use USERELATIONSHIP as they are inactive relationships but can't seem to show this properly based on the type and country.
Thanks All!
@swwong1 , Create a measure with removefilters or all to remove the filter of type and date
All sales = calculate(Sum(Table[sales]), removefilters(Table[Type], Table[Date]) )
or
All sales = calculate(Sum(Table[sales]), all(Table[Type], Table[Date]) )
Learn Power BI: All, allselected, removefilters,allexcept- https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |