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.
Good afternoon,
I have a problem. I need to have in one table the number of episodes per problem, in another the total number of episodes and in another the %. (There are more than 3 rows), so the total is 9508.
That´s right.
The problem is when I filter doing TOP 10 per PROBLEMA_DESC: Since I have now 10 rows instead the 15 that I had in the past, the total number of episodis change to 6690 so percentages change as well.
Num_Episodis = COUNTROWS(SUMMARIZE('Table1,'Table1'[EPISODI],'Table1'[PROBLEMA_DESC],'Table1'[PROBLEMA_CODI]))
NF_Num_Episodis = CALCULATE(COUNTROWS((SUMMARIZE('Table1','Table1'[EPISODI],'Table1'[PROBLEMA_DESC]))), ALLSELECTED('Table1'))
%_Episodis = [Num_Episodis]/[NF_Num_Episodis]
I don´t know how to have a column that doesn´t work with the TOP N filter. I tried with ALLEXCEPT, ALL... but it doesn´t work and I'm not sure if that´s is possible or do a constant.
Thank you in advance.
Solved! Go to Solution.
@silvias - Yeah, it's a pain and annoying really. ALL is documented as removing all filters but then it doesn't if you use the Filters pane. I wish it wasn't like that.
@silvias - If you are doing a filter in the Filter pane, then that pre-filters the data such that DAX calculations lose access to the raw data that is filtered and thus ALL, etc. will not be able to "bring those rows back" so to speak. Are you using a page filter?
@silvias - If it is in the Filter pane, it is going to pre-filter the data such that the DAX does not have access to the filtered data and there is no getting around it. This has come up before in other threads and to the best of my knowledge there is no work-a-round.
Seems like @Pragati11 was headed down the same path.
@Greg_DecklerThank you, Greg.
I guess I'll have to show all the values without TOP 10 if I want to be shown all of them. Thank you!
@silvias - Yeah, it's a pain and annoying really. ALL is documented as removing all filters but then it doesn't if you use the Filters pane. I wish it wasn't like that.
Hi @silvias ,
Just want to check how you are using TOPN filter on this visual?
Thanks,
Pragati
Hi @Pragati11
thank you for your answer. I'm putting the Top N filter on my visual only from FILTER PANE:
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |