Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Problems with The Visualization of a Measure With Percentage Variables

Good! [] The consultation is in order to better organize the measures. I have several measures to achieve a visualization and I want to group it into a single measurement. That is, I have severa...
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Syndicate_Admin 

     

    Sorry for the late reply. I misunderstood it previously. Please try this new measure. The updated pbix file is attached. 

    Measure 2 = 
VAR monthTotal = CALCULATE(SUM(Payments[Amount]),ALL(Payments[Customer]))
VAR customerTotal = SUM(Payments[Amount])
RETURN
DIVIDE(customerTotal,monthTotal)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Good. Thank you very much for your time.
I still don't make it. If I get the idea of doing it that way and that's what I was trying.
What you do if I do it by calendar month, the expected result is achieved. But I have related the following calendar table, filtering by calendar(date)


CALENDAR = ADDCOLUMNS(
CALENDAR(
DATE(2018,01,01),
MAX(Payments[Date])),
"Year", YEAR([Date]),
"My", MONTH([Date]),
"My numbers",FORMAT([Date],"mmm"),
"Day", DAY([Date]),
"Day of the week", WEEKDAY([Date],2),
"Current Year",YEAR([Date])-YEAR(TODAY()),
"Current Month",(YEAR([Date])*12+MONTH([Date]))-(YEAR(TODAY())*12+MONTH(TODAY())),
"Current Day",VALUE([Date])-VALUE(TODAY())
)

filtro intento.JPG

Again, thank you for your time. Best regards.