Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summarize Table

Good Morning    I am currently building a dashboard, and ive stumbled across an issue. Ive created a Summarize table with the following DAX   Weekly Attendance = SUMMARIZE('BSCA Attendance','BSCA...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • daxer-almighty's avatar
    daxer-almighty
    Solution Sage
    5 years ago

    Hi Greg_Deckler.

     

    You remember the thread about newbies? 🙂 Frequent Visitor... I'll be reminding you of them for a while so that you get the scale of what I was talking about. And I strongly hope you already know why you should never use SUMMARIZE to do any calculations in it. If not, then I'd recommend going to www.sqlbi.com and finding the article by Marco that treats this topic in depth.

     

    And yes, I know it's not a measure we're talking about here. Nevertheless... However, it's kind of clear from the description that the asker is after a measure since he believed he could filter this table dynamically by dates.