Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Problem with ALL/ALLSELECTED while creating a heatmap

Hey there.   Here's the file link used for this example: heatmap.pbix    I'm currently working on the creation of a heatmap by using a matrix. In order to do so, I'm trying to retrieve the moment...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    Please update the formula of your measure [heatmap] as below and check if it can return the correct result. Please find the details in the attachment.

    heatmap = 
VAR __tbl =
    CALCULATETABLE (
        SUMMARIZECOLUMNS (
            'd_calendar'[week_en_us],
            'd_calendar'[day_name_en_us_with_day_name],
            'd_hours'[day_moment],
            'd_hours'[hour],
            "@count_ticket",[count_tickets]
        ),
        ALLSELECTED(),
        VALUES('d_calendar'[week_en_us])
    )
VAR __result =
    MAXX ( __tbl, [@count_ticket] )
RETURN
    __result

    Best Regards

lbendlin's avatar
lbendlin
Super User
1 year ago

 ALLSELECTED() is too broad.  Be more specific on which filter you want to remove (in your case it's the day name)

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous's avatar
Anonymous
Not applicable
1 year ago

I don't think you've even read the entire message, as the link to the file is literally in the second line of my text. The sample data is in that file.

 

What did I include that is unrelated to the issue?