Mam, I am having the data of sales amount having the column State and District. I have created a measure for total sales. and created 2 Slicer i.e. State and District and I have sync slicer for all the pages of the report. I have created a table with column State and Sale. If I don't selected any slicer from state then default value should be State Column and Sale Column and If I select any state the respective district of the state should come i.e. District column in place of State Column and Sale column. Please advise sir, how it can be done.
what is logic behind such (last )example when there is clearly salesid column is availaible in both table and you can perform things without making this dax
Please share your datasets sister for our training purposes .. Where do we get huge datasets for practice sessions ? Thanks a lot for your efforts and knowledge transfer ❣️
Created measure to manage blank values as well.. TOTALAMOUNT = VAR GETSALESID=SELECTEDVALUE('Row ID_Car DATA'[Row ID]) RETURN IF(ISBLANK( CALCULATE(SUM(Orders[Sales]),Orders[Row ID]=GETSALESID)),"PLEASE SELECT A VALUE", CALCULATE(SUM(Orders[Sales]),Orders[Row ID]=GETSALESID)) This is actually an interview question that I got ☺️, but they have asked to update the selected value in the card visual, and if nothing is selected then the text should appear like "please select a value" Thanks @hima
You have explained it in very simple way. thankyou so much
Very much helpful. Thanks alot
Much needed video... thanks for this 🤗
Very crystal clear explanation,thank you for your effort and hard work.
Thank you
Good morning. Thanks for the video.
Fantastic, good explanation. thanks for your effort
Thanks for sharing
Very useful learning techniques✌
It is very clear. Thank you
Thank you for explaining
Very clear n nice😊
Good
as always very clear explanation, thanks for sharing
Thank you!
Very well explained superb😍
Thank you
Thank you
Thank you ❤️
super
Hi sister can you please make a video on cross report and thank you for your efforts, all topics as you shared in UA-cam it is very useful to use 😊
Ma'am you are so beautiful, and so does your explanation. I learned many bi concepts through your videos. Very beautiful
Thank you 🙂
really good Bindu
Without variable can I get result
Hii ..can you upload the video ...
How to explain project in interview for power bi !! Please make it ..
Mam, I am having the data of sales amount having the column State and District. I have created a measure for total sales. and created 2 Slicer i.e. State and District and I have sync slicer for all the pages of the report. I have created a table with column State and Sale. If I don't selected any slicer from state then default value should be State Column and Sale Column and If I select any state the respective district of the state should come i.e. District column in place of State Column and Sale column.
Please advise sir, how it can be done.
Make videos on scenario based questions which are asked in interview?
Sure
Perfect 👌👌👌 Lecture and topic.
Can you please take any real time Project from scratch ????
Sure
@@TheHimaBindu Hi ma'am real-time project with loading data from SQL would be a great help for us...
what is logic behind such (last )example when there is clearly salesid column is availaible in both table and you can perform things without making this dax
can you please make presentation on z order
I will
Hello sister please make a playlist of DAX Series.
Hi. Sure I will
Please share your datasets sister for our training purposes .. Where do we get huge datasets for practice sessions ? Thanks a lot for your efforts and knowledge transfer ❣️
Hi Dinesh. I usually get them from microsoft site.
See min 5:30. It is shown :)
Hi Akka
Hello
Power bi प्राइवेट टेबल बना सकते हैं??
Can use hindi language please 🙏
Created measure to manage blank values as well..
TOTALAMOUNT =
VAR GETSALESID=SELECTEDVALUE('Row ID_Car DATA'[Row ID])
RETURN
IF(ISBLANK(
CALCULATE(SUM(Orders[Sales]),Orders[Row ID]=GETSALESID)),"PLEASE SELECT A VALUE",
CALCULATE(SUM(Orders[Sales]),Orders[Row ID]=GETSALESID))
This is actually an interview question that I got ☺️, but they have asked to update the selected value in the card visual, and if nothing is selected then the text should appear like "please select a value"
Thanks @hima