Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |