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.
Hi,
I appied the below and the respose which iam getting is wrong.
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi Greg,
Thank for the suggestion, I tried my best to work this out with out sucess...
Ajith
Paste the sample data as text please. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
,Recovered,US,2020-04-07 23:04:49,,,0,0,21763,0,"Recovered, US" ,,Reunion,France,2020-04-07 23:04:29,-21.1151,55.5364,358,0,40,318,"Reunion, France" ,,Saint Barthelemy,France,2020-04-07 23:04:29,17.9,-62.8333,6,0,1,5,"Saint Barthelemy, France" ,,Saint Pierre and Miquelon,France,2020-04-07 23:04:29,46.8852,-56.3159,1,0,0,1,"Saint Pierre and Miquelon, France" ,,Saskatchewan,Canada,2020-04-07 23:11:15,52.9399,-106.4509,260,3,0,0,"Saskatchewan, Canada" ,,Shaanxi,China,2020-04-06 01:14:34,35.1917,108.8701,256,3,246,7,"Shaanxi, China" ,,Shandong,China,2020-04-07 00:55:26,36.3427,118.1498,781,7,755,19,"Shandong, China" ,,Shanghai,China,2020-04-07 06:21:55,31.201999999999998,121.4491,538,6,406,126,"Shanghai, China" ,,Shanxi,China,2020-04-05 00:58:54,37.5777,112.2922,138,0,133,5,"Shanxi, China" ,,Sichuan,China,2020-04-07 01:35:16,30.6171,102.7103,560,3,541,16,"Sichuan, China" ,,Sint Maarten,Netherlands,2020-04-07 23:04:29,18.0425,-63.0548,40,6,1,33,"Sint Maarten, Netherlands" ,,South Australia,Australia,2020-04-07 23:11:31,-34.9285,138.6007,411,1,53,357,"South Australia, Australia" ,,St Martin,France,2020-04-07 23:04:29,18.0708,-63.0501,32,2,7,23,"St Martin, France" ,,Tasmania,Australia,2020-04-07 23:11:31,-42.8821,147.3272,89,2,26,61,"Tasmania, Australia" ,,Tianjin,China,2020-04-07 00:20:57,39.3054,117.323,180,3,151,26,"Tianjin, China" ,,Tibet,China,2020-02-23 11:19:02,31.6927,88.0924,1,0,1,0,"Tibet, China" ,,Turks and Caicos Islands,United Kingdom,2020-04-07 23:04:29,21.69400000000001,-71.7979,8,1,0,7,"Turks and Caicos Islands, United Kingdom" ,,Victoria,Australia,2020-04-07 23:11:31,-37.8136,144.9631,1191,11,620,560,"Victoria, Australia" 00078,,Virgin Islands,US,2020-04-07 23:04:49,18.3358,-64.8963,43,1,0,0,",Virgin Islands,US" ,,Western Australia,Australia,2020-04-07 23:11:31,-31.9505,115.8605,460,4,162,294,"Western Australia, Australia" ,,Xinjiang,China,2020-03-08 05:31:02,41.1129,85.2401,76,3,73,0,"Xinjiang, China" ,,Yukon,Canada,2020-04-07 23:11:15,64.2823,-135.0,7,0,0,0,",Yukon,Canada" ,,Yunnan,China,2020-04-07 00:20:57,24.974,101.48700000000001,184,2,173,9,"Yunnan, China" ,,Zhejiang,China,2020-04-07 02:06:38,29.1832,120.0934,1265,1,1230,34,"Zhejiang, China" ,,,Afghanistan,2020-04-07 23:04:29,33.93911,67.709953,423,14,18,391,Afghanistan ,,,Albania,2020-04-07 23:04:29,41.1533,20.1683,383,22,131,230,Albania ,,,Algeria,2020-04-07 23:04:29,28.0339,1.6596,1468,193,113,1162,Algeria ,,,Andorra,2020-04-07 23:04:29,42.5063,1.5218,545,22,39,484,Andorra ,,,Angola,2020-04-07 23:04:29,-11.2027,17.8739,17,2,2,13,Angola
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |