I am having quite a similar data set, but getting following Expression.error "we cannot convert a value of type list to type table". Any idea which why it's not detecting _ as the table, but as list? Thanks in advance for your support!
Hi, I am trying to do something similar but I cannot transform data in the query because I have to use the data for other measures. Can you show how to do the exact same thing using Dax measures?
Thanks for your share. It helped me on a project. Need your help on one more thing. Can I able to generate the distinct count as running count? Instead of 2, it should reflect as 1,2.. and for 3, it should be 1,2,3.
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase. So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
when you group the data, you are changing the granularity. you are combining some rows based on values of a column, so they will be aggregated. if you still want other columns, then you have to include them in the group by key columns
![Stromae, Pomme - “Ma Meilleure Ennemie” (from Arcane Season 2) [Official Visualizer]](http://i.ytimg.com/vi/1F3OGIFnW1k/mqdefault.jpg)
Man that a big relief 😢 thx it’s like a year searching for that 🎉
I'm glad it helped! 😊
Hii, It's very very Helping for me.... Thanks for this.....
This was the answer ive been looking for all day! thanks!
Easy teaching easy learning. Thank you.
Thank you for such a helpful video. I enjoyed learning this for a project I am working on right now!
Glad it was helpful!
Thanksss! this is exactly what i was looking for
Glad I could help!
amazing content
Thank you so much. it helped . can we get the data by year in this?
Thanks this solved my issue but why Microsoft couldn't just include the option in the drop down in the first place.
I am having quite a similar data set, but getting following Expression.error "we cannot convert a value of type list to type table". Any idea which why it's not detecting _ as the table, but as list? Thanks in advance for your support!
= CALCULATE(DISTINCTCOUNT('Estado de OT'[Orden]),FILTER( 'Estado de OT','Estado de OT'[Estado De OT] "Cerrada")) ejemplo
Hi, I am trying to do something similar but I cannot transform data in the query because I have to use the data for other measures. Can you show how to do the exact same thing using Dax measures?
Hi did he ever reply? I am looking for the same solution
Is there a way to list only LATEST records from a table using that?
Thank you! Very easy to follow and works!
Thanks for your share. It helped me on a project. Need your help on one more thing. Can I able to generate the distinct count as running count? Instead of 2, it should reflect as 1,2.. and for 3, it should be 1,2,3.
Hi Sir,
How can we differentiate Distinct and Unique values normally we can view it in column profiling.
Thanks
how to change to avoid counting blank. I used the same formula, but its counting blanks. Thanks
Sir, pls guide me to do indexing based on two column. Ex ... A. India - 1, and it gives 1 whenever A. India comes together.
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
How are you able to use Table.RowCount which accepts a table with List.Distinct which returns a list?
After clicking group by, Why the other column hides and does not show up? I want to keep all the other columns of the table. Any solution to it?
when you group the data, you are changing the granularity. you are combining some rows based on values of a column, so they will be aggregated. if you still want other columns, then you have to include them in the group by key columns
@@RADACAD Thank you for your reply. I'm new in Power BI and learning new stuff. I will try this and hope it solves my issue!
Dear sir i want m code apply how to apply =if(a2=a3,0,1) this formula a column i want to apply for uniq count how to apply if condition
Excelente