Shashank sir , We can write this only --> Count = CALCULATE(COUNT('Sample'[Product])) there is no use of allexcept here because this calculate will do the context transition
hi,we can do in this way also Count = VAR Currentrow = 'Table (8)'[Model] RETURN CALCULATE ( COUNT ('Table (8)'[Model]), FILTER ('Table (8)', 'Table (8)'[Model] = Currentrow ) )
Hi Shashank, I have been following your channel for quite sometime now and I must say your scenario based questions are very unique and helpful in interview preparation. I recently encountered a scenario based question in an interview in a company and would be grateful if you could help in finding the solution. The question was 'How will you create buttons for toggling if you want to get sales and revenue. The toggle button should appear on the page.'
Hey @learnwidgiggs i need your help solve a problem statement. I have one excel datasource and I have created a report having multiple chart in power bi desktop, now i updated the column header name in the data source and i want updated name to reflect in every chart without any manual intervention. How can I achieve it? Please guide me
bro I dont understand why we are using allexcept here, here we have only one column, even if i use the general "calculate(count(table[productname])" we will get the same output. Please explain
Hello Shashank, Greetings! I am working as a Power BI Developer. I got knowledge on SQL. But I wan upgrade my skills but not sure what I exactly I should learn. Should I go for Power platform or Azure. If Azure... what exactly I need to learn in azure. Kindly suggest. Best, Shafiq Ahmed.
If you add any other column to this table, then you will face circular dependency error... So its safe to use allexcept for window function like behaviour
Actually in table iPhone 11 and iPhone 13 repeat in table but we want total count of brands only But your results is iPhone11-2 iPhone 12-2 Like that But we want iPhone11-total sum iPhone 12-totalsum iPhone 13-totalsum Like that we want how Will you create
Shashank sir , We can write this only --> Count = CALCULATE(COUNT('Sample'[Product])) there is no use of allexcept here
because this calculate will do the context transition
you can also use calculate(count(product), filter(sample,earlier(product)=product) )
CALCULATE(COUNT('Sample'[Product])) only this is sufficient
hi,we can do in this way also
Count =
VAR Currentrow = 'Table (8)'[Model]
RETURN CALCULATE ( COUNT ('Table (8)'[Model]),
FILTER ('Table (8)',
'Table (8)'[Model] = Currentrow
)
)
CALCULATE(COUNT('Sample'[Product])) only this is sufficient
Sir kindly share interview questions for freshers who are becoming Power BI developers with no company experience
Noted.
simple Count = CALCULATE( COUNT(Phone[phone])) is also giving the results
yeah, calculate is doing the context transitioning
If you use simple calculate (count (column)) we could have achieved this
Even, Custom = CALCULATE(COUNT(Sheet4[Product])) yields the same result.
yeah, calculate is doing the context transitioning
Hi Shashank,
I have been following your channel for quite sometime now and I must say your scenario based questions are very unique and helpful in interview preparation.
I recently encountered a scenario based question in an interview in a company and would be grateful if you could help in finding the solution.
The question was 'How will you create buttons for toggling if you want to get sales and revenue. The toggle button should appear on the page.'
Using bookmark..we can achieve this thing
Can you please make video on row context, filter context and context transition. Tried to watch videos on youtube but Iam not able to understand 😢.
Hello shashank,
without using ALLEXCEPT function, it shows same result...
so why we should be use the ALLEXCEPT function
Hi Shashank,
How to calculate total sales using variables and returns. don't use calculate
Hey @learnwidgiggs i need your help solve a problem statement. I have one excel datasource and I have created a report having multiple chart in power bi desktop, now i updated the column header name in the data source and i want updated name to reflect in every chart without any manual intervention. How can I achieve it? Please guide me
Hi...are you rename default columns in power bi desktop?
bro I dont understand why we are using allexcept here,
here we have only one column,
even if i use the general "calculate(count(table[productname])" we will get the same output. Please explain
yeah there is no need of allexpect here, CALCULATE(COUNT('Sample'[Product])) only this is sufficient calculate is doing the context transitioning here
Nicely explained.
Thanks 👍
Welcome 😊
Can we use the "Countif" formula
Hello Shashank,
Greetings!
I am working as a Power BI Developer.
I got knowledge on SQL.
But I wan upgrade my skills but not sure what I exactly I should learn.
Should I go for Power platform or Azure.
If Azure... what exactly I need to learn in azure.
Kindly suggest.
Best,
Shafiq Ahmed.
Depends on your interest
If going with Azure then learn ADF and Databricks
But can't we simply drop the product column as value which will aggregate it as count, also there is not other filter context in question...
If you add any other column to this table, then you will face circular dependency error... So its safe to use allexcept for window function like behaviour
Hi we can solve it with earlier function also
CALCULATE(COUNT('Sample'[Product])) only this is sufficient
Actually in table iPhone 11 and iPhone 13 repeat in table but we want total count of brands only
But your results is
iPhone11-2
iPhone 12-2
Like that
But we want
iPhone11-total sum
iPhone 12-totalsum
iPhone 13-totalsum
Like that we want how Will you create
in calculate column you will get result like this only, for the result u are saying u have to use matrix visual where we use a measure