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.
Need help on same query. i have data for last 7-8 months and want to lock same value which you locked in card visualization in shared power BI file. i wish to be have same output with month wise, could you please help me on this ? Thanks
please refer below link and attached screen snap
hi, @Amardeep100115
You could use "ALLxxx" functions in DAX to create a measure to get it.
https://docs.microsoft.com/en-us/dax/all-function-dax
You could add a conditional like ALL('Date' ) ,ALL('Date' [Month]) in the measure formula.
If you still have the problem, What is "month wise"?
please share a simple sample pbix file and expected output.https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
you can find the working file on below link
OR find on below link
hi, @Amardeep100115
Please share your own sample data and expected output.
In that post, it could use "ALLxxx" functions in DAX to create a measure to get his requirement,
you could get it by the same logic, if you have the problem, Please share your own sample data and expected output.
Best Regards,
Lin
Please visit to below link to access required sample data
i wish to be have Base Amt should be lock in Multi Card visual month wise,
hi, @Amardeep100115
We couldn't access to your sample pbix file.
Please upload again.
Best Regards,
Lin
hi, @Amardeep100115
If you could use this formula to create a measure
Measure 2 = CALCULATE(SUM(data[Amount Base]),ALL(data[Month]))
Result:
Best Regards,
Lin
Could you please share me working file?
hi, @Amardeep100115
Here is pbix file, if you have any problem, please show the expected output by it.
Best Regards,
Lin
If you notice in below table i have clicked on 2019 bar in bar graph and in multi card visual filtered portfolio $/SF and locked value is global portfolio $/SF is deffernt in below both snaps
i have used measure for global portfolio
hi, @Amardeep100115
I check the data, for every Compaany ID, it has the same "Amount Base" for each Month.
So when you check any month, it won't change.
and for your own example, That's not what you're looking for?
what is your expected output?
Best Regards,
Lin
Sorry for confusion,
If you see the below snap in that there two tiles for $38, 1) Filtered portfolio $/Sqft and 2) Global portfolio $/Sqft
i wish to be have two different measure one of that display Filtered Base Amt $/Sqft and another is Global base amout $/Sqft like Img 2.
revised data in file, please visit in below link:
https://1drv.ms/u/s!Ai3rGPgy20kLwEsQezJ-G1LO6jym?e=EtUNWD
Img 2:
Img 1:
Not Working on my P
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |