Forum Discussion

diego-jd's avatar
diego-jd
Frequent Visitor
2 years ago
Solved

Aggregate measure by value

I am using the Usage Metrics Report dataset to create a Dashboard. There, I created the measure days_without_views, that calculates the days that have passed since the report was last seen with this ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi diego-jd 

     

    You may create a new measure as below, which uses your current measure for each area

    total =
VAR vtable =
    SUMMARIZE (
        'ReportTable',
        'ReportTable'[Report],
        'ReportTable'[Area],
        "days", [days_without_views]
    )
RETURN
    SUMX ( vtable, [days] )

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi diego-jd 

 

You may create a new measure as below, which uses your current measure for each area

total =
VAR vtable =
    SUMMARIZE (
        'ReportTable',
        'ReportTable'[Report],
        'ReportTable'[Area],
        "days", [days_without_views]
    )
RETURN
    SUMX ( vtable, [days] )

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!