Can't display the visual

DAX DAX Calculations
1

I have changed the source files in my original PBIX and now one of the visuals will not display.

In the old version my DAX was exactly the same as my new DAX (and worked).

Not sure what is going on. This should give me a cumulative measure, right?

Chris

Cumulative School Count =
CALCULATE( [Count of Incident Type for 48],
FILTER( ALLSELECTED( Date ),
‘Date’[Date] <= MAX( ‘Date’[Date] ) ))

2

Hello @chrisgreenslade,

Thank You for posting your query onto the Forum.

Can you please upload the working of the PBIX file? So that members of the forum can provide you the results in a better and efficient manner. Without PBIX file it will just simply involve the guess work and will consume the time of the members.

Thanks and Warm Regards,
Harsh

3

I can’t, it’s too large a file.

4

Hello @chrisgreenslade,

If the file is too large than you can upload it in the Google Drive and upload the link here so that it’s accessible by members.

Thanks and Warm Regards,
Harsh

5

What is inside this measure?

6

Count of Incident Type for 48 =

CALCULATE(

COUNTA(‘Incident Events’[Incident Type]),

‘Trigger Events’[Code] IN { 48 }

)

7

Hi @chrisgreenslade , we’ve noticed that no response has been received from you since the 10th of March.

We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

As @Harsh mentioned above, if the file is too large then you can upload it in the Google Drive and upload the link here so that it’s accessible by members.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.