Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
1. I added a calculated column by this formula:
Kindy pls give any suggestion
Thanks!
JPY
Solved! Go to Solution.
hi, @JPY
You could use this formula:
Measure = var _table= SUMMARIZE(Query1,Query1[User Name],Query1[CreationTimeUTC.1],"Column",DISTINCTCOUNT(Query1[Column])) return SUMX(_table,[Column])
Result:
Best Regards,
Lin
hi, @JPY
You could use this formula:
Measure = var _table= SUMMARIZE(Query1,Query1[User Name],Query1[CreationTimeUTC.1],"Column",DISTINCTCOUNT(Query1[Column])) return SUMX(_table,[Column])
Result:
Best Regards,
Lin
@JPY -
Whenever you want to get a total value in your measure, it means that you need to remove a filter. To remove a filter, you need to apply some sort of ALL. Which ALL function to use and which columns are relevant is situational - which column(s) need a modified filter context?
Cheers,
Nathan
Hi Nathan @Anonymous ,
Thanks for your reply!
In my dataset, I have mutiple different users and creation times.
Besides, I have Year and Month slicer in my dashboard. I want the measure can sum up the "distinct sum" according to month and year. For example, if I choose July 2018, Auguest 2018, September 2018 and Feb 2019 then the measure will tally to 9 as per my screenshot above. Since I want to group the measure so that I can have a slicer to filter.
Or do you know there is another way to achieve it?
Thanks.
JPY
@JPY -
To get the Total, you will want to use ALLSELECTED.
I don't think you'll be able to use a measure as a slicer though.
Hi @Anonymous,
Could you please explain in more detail? Where should I apply the Allselected formula?
Thanks.
JPY
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |