Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sector and Geography granularity issue

I have a table Time

 

When the user selects period from february 2020 tç february 2021,I expect to get the following result

 

 

But what I get

 

 

 

How to correct the issue with the granularity?

 

Here is the pbix file https://drive.google.com/file/d/1vf0khr7MbnDTVBzycNgJsaJufwd9F8D_/view?usp=drivesdk

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try

    sumx(summarize(Table, Table[project Name], table[time]),[time])

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I need to summarize value of time by project name regardless sector and geo. So it doesn't work. 

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Anonymous , Try

        sumx(summarize(Table, Table[project Name], table[time]),[time])