I have 3 measures. Sales CY, Sales PY, and Sales YoY. Sales YoY Dax is just simply Sales CY - Sales PY. Requirement is these 3 measures each have to be in their own column of a visual table to allow sort. When I try to optimize the Dax using Dax studio I find that the YoY measure is taking the longest naturally. Is there a way to tell that column just to use the queries from CY and PY measures already being sent from the other two columns. I am sending three queries and don’t want to. I only want to send 2. I was really hoping visual calcs would solve this. Essentially I want to only send queries necessary. Then YoY or YoY % I want to simply just use the already run queries. Simply put I want to only query a measure once but then use it in multiple columns in different ways. Any thoughts?
Thanks for the comment! A technical question this detailed would be best to place on the Fabric community forums where there's a lot more experts, and you can also provide sample data and files :) community.fabric.microsoft.com/
The visual display is the rendering. Sorry if that was misquoted. The other does encompass waiting for other visuals to load though! Here's the quote for that from the MSFT Document Other - This is the time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.
Awesome session once again, Reid with one of most profound minds in our BI universe! Thanks!
It was a blast having him on!
Unfortunatelly you can give only one thumb up, I would give a hundred!
the current version of Dax Studio STILL doesn't work for define dependent measure.
I have 3 measures. Sales CY, Sales PY, and Sales YoY. Sales YoY Dax is just simply Sales CY - Sales PY. Requirement is these 3 measures each have to be in their own column of a visual table to allow sort. When I try to optimize the Dax using Dax studio I find that the YoY measure is taking the longest naturally. Is there a way to tell that column just to use the queries from CY and PY measures already being sent from the other two columns. I am sending three queries and don’t want to. I only want to send 2. I was really hoping visual calcs would solve this. Essentially I want to only send queries necessary. Then YoY or YoY % I want to simply just use the already run queries. Simply put I want to only query a measure once but then use it in multiple columns in different ways. Any thoughts?
Thanks for the comment! A technical question this detailed would be best to place on the Fabric community forums where there's a lot more experts, and you can also provide sample data and files :)
community.fabric.microsoft.com/
I don’t think that the “other” time has anything to do with the rendering. It’s wait time in the AS model. 🤷🏼
The visual display is the rendering. Sorry if that was misquoted. The other does encompass waiting for other visuals to load though! Here's the quote for that from the MSFT Document
Other - This is the time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.